# 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 %}

<figure><img src="/files/1NectQThdmC5cl8IfDcp" alt=""><figcaption></figcaption></figure>

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 %}

<figure><img src="/files/ARcCjINV0pfSSY2OGZAv" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.avoautomation.com/avo-assure/actions/generic/loops-and-condition-operations-1/get-param/adv-parameter.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.