Check the column exist

This is a pre-built action in Avo Assure and comes under @Excel element. This action verifies that a specific column is present or Not present in an Excel file and save the result in dynamic variable.

Syntax

Input Value: <column name>

Argument	Description
column name (Required)	Required column name to check specific column is present or not

Output Value:

Argument	Description
<Dynamic Variable>(Optional);<Dynamic Variable>(Optional)	This variable holds the results in True and False

Example 1

The Check the Column Exist action takes the column name from the Input Value column (e.g., Employee ID) and checks whether it exists in the Excel file. The result is stored in the {ColumnExist} variable, and the execution status is stored in the {Status} variable with the following possible values:

True – if the column is found. False – if the column is not found or an error occurs.