I have a input data in the excel, Once the first loop action completed, Bot should ignore & not process next entire row values.
Likewise need process all rows
Note: I have to use , ignoring rows(3,5 and 7) values with before rows loop itself. So that once completed the loop ignoring the next row.
And finally need to end the loop.
You could iterate the rows in a “For Each row in Data Table” activity.
Here you can set up the required If-sentences to check whether or not the row meets your criteria.
If the row does’nt meet your criteria, you could simply assign a distinctive value that you can filter afterwards.
Assign CurrentRow("Name") = "ToBeDeleted"
And then use a “Filter Data Table” activity to remove rows where: