When Field "Entity" is not in Column A, then "Error: Entity must be in Column A"

[Yogish]

Hi 

When i pass on the input excel file, it should validate the first field "[Entity]" in column A else should throw an error saying "Error: Entity must be in Column A"

Note:input file may contain the field "[Entity]" in column B or column C. but still should throw the error.

Basically its a field validation which i require your suggestions.

Thank you.

[DavidP · Accepted solution]

Hi @Yogish 

You can use a Test tool, like this: