# ADV Parameter The **ADV (Advance)** parameter is used in the **Get Param** action when applying data parameterization in Avo Assure.\ It helps you retrieve test data and execute test cases, especially when working with large or multiple datasets stored in a single Excel sheet. ## **Purpose and Usage** * The **ADV** option is used when there are multiple data sets related to multiple test cases stored in one Excel sheet. * It is helpful when testing the same test cases across different environments (for example, QA, UAT, or Production). * By using ADV, Avo Assure can dynamically pick the right data set during execution, reducing the need to maintain multiple Excel files. ## Organizing Test Data in Excel for Multiple Test Cases 1. When adding the test data of multiple test cases in a single Excel sheet, make sure to segregate the test data by defining their names as the header values. {% hint style="info" %} **Note:** Ensure the header values and test case names are the same so that they can be identified easily during execution in Avo Assure {% endhint %}

2. When adding the test data of multiple test cases that are linked together in an end-to-end flow within a single Excel sheet, provide the header value as the name of the end-to-end flow. {% hint style="info" %} **Note:** Avo Assure identifies the correct set of test data for the entire end-to-end flow during execution. {% endhint %}