Dear Team, How to handle exception for various column data in Excel

[Lokesh_M2 (Lokesh M)]

I want to handle business exceptions for every column of data.
For example Age column third row there is a character instead numeric. I need to show the business of the particular row issue.

Help me with this.Tq

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @Lokesh_M2,
For each row in data table,check by using if condition. currentrow(“Age”).isnumeric -checks the condition and in else section you can throw a business exception like
New businessruleexception(“Age is not numeric”)

[loveleet_Saini]

Hi @Lokesh_M2

Surround the Workflow with TryCatch where you are Column Value.

regards
Loveleet Saini

[Lokesh_M2 (Lokesh M)]

Thank you for suggestion