Test Data

The Test Data option in the Execution Configuration allows you to specify or override the ADV (Advance) Excel sheet path that holds the test data for parameterization. This option takes priority over the ADV excel file path defined in the test step or Testcase. It allows you to update or change the data source without modifying the test design, making it easier to manage the data used for a specific execution. When the test runs, Avo Assure uses the ADV Excel file path defined under the Test Data section of the Execution Configuration instead of the one provided in the test step.

Creating the excel sheet using ADV option​

  • When you add test data for multiple Testcases in a single Excel sheet, make sure you separate the data by using the Testcase names as header values.

Note:

  • Ensure the header values match the Testcase names so that Avo Assure identifies the correct data during execution.

  • If you update the Excel sheet, ensure that the header values in the sheet match the variable names used in the Testcase.

  • When you add test data for multiple test cases stitched together in an end-to-end flow within a single Excel sheet, make sure you use the name of the end-to-end flow as the header value.

Steps to Use an ADV Excel File in Test Data:

  1. On the Execution tab, navigate to Configuration window.

  2. Expand the Test Data from the Configuration.

  3. Enter the ADV Excel file path along with the sheet name, and specify ADV (for example: C:\Users\Downloads\Sample Data.xlsx;Sheet1;ADV) for the file that contains multiple data sets.

  4. Select Save to save the configuration.

  1. Execute the Testcase. Avo Assure automatically picks the correct data set from the ADV Excel file during execution.

Last updated

Was this helpful?