Question

2
Replies
30
Views
Close popover
Zach Taylor (ZachT124)
Transplace
Data Scientist
Transplace
US
ZachT124 Member since 2021 16 posts
Transplace
Posted: March 23, 2021
Last activity: March 25, 2021
Solved

Skip to next index/Excel row in forLoop

I am working on a project where I am reading in excel values and storing them as global variables so that I can use those values in other automation files. My main Automation file that starts the project is reading in data, making a decision and then using that rows data to fill in form data, download and move the file. When I download the file I am writing to a column that indicates if I have downloaded the file or not. I need away to prevent duplicate downloads and to end the file on the last row of the Excel file. What I am trying to do is create logic that looks for the completed download value. If the value is "Yes" then I want to skip to the next row in the excel file. How can I skip to the next row in the excel file if the condition is "Yes"? I have all of the logic I just can not figure out how to move to the next row in the Excel file. 

 

Pega Robotic Process Automation 19.1 Robotic Process Automation Financial Services Data Scientist