I have a String DataTable (can vary in amount of rows) containing 9 columns. Columns 0-5 are the result from a read range from Sheet 1 in an Excel sheet. Column 6-9 are information containing “Exception” or “No exception” concerning different categories.
You can take a loop in for each row to iterate through each column of that row take check condition for exception using if and contains function and take the required information from that row in variables and build a new datatable based on that using add datarow.
Cheers share your sheet for flow.
like by default datable column index is 0 for first column so in this case you can write 0 also but i have wriiten 6 is the column from EXCEPTION values are startting
that your column is 7 less than 10 is for all coumn from 6 to 9.