Hi, I am new in UiPath and try to do a program that can read all row in column B and column S. If the row in column B don’t have a date then it will go for the next row and continue checking, If the row in column B have a date then will check for the same row in column S, if column S not match with the condition then will send file to wrong folder, if column S is match with the condition then will continue checking for the next row until all the column B and column S in whole file has been checked, then will send file to correct folder. The problem i face is the program will only check once. For example, first row is correct and third row is wrong, but the program i do will only check for first row then direct send file to correct folder. So, how to check all the row in two column?
This are the UiPath program i try to do, please take a look and how should i change?
Main.xaml (13.7 KB)
And this is the excel file that will send to wrong folder.
sample time sheet.xlsx (263.4 KB)