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

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

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”)

Hi @Lokesh_M2

Surround the Workflow with TryCatch where you are Column Value.

Loveleet Saini

Thank you for suggestion

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.