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 helps to ensure that the file includes the required data fields

Syntax

Input: <column name>

Argument	Description
column name (Required*)	Particular column name

Output: <Dynamic Variable>(Optional)

Example 1

A payroll department maintains an Excel sheet containing employee salary details. Before processing payroll, the system must verify that the Employee ID column is present to ensure data accuracy.

Note: Validation of Example

Verifying for Employee ID column → Returns True (column exists), allowing payroll processing.

Verifying for Bonus column→ Returns False (column missing), triggering an alert.

Example 2 A payroll department maintains an Excel sheet containing employee salary details. Before processing payroll, the system must verify that the Bonus column is not present to ensure data accuracy.