I am working with csv file automation where I need to read all the rows of file. One of the column value needs to meet standard format. If the value fails to comply then the bot should reject that value, not execute subsequent workflows and should iterate through next row value in that csv file. Can anyone suggest me how to get it done.
I believe you can implement this using an ‘If’ condition inside your for each loop. Provide a condition to check if you value meets the standard format, put your workflow inside the ‘Then’ sequence keeping ‘Else’ block empty or any log that you would like to capture when it fails.
Let me know if it helps.