Question
Tech Mahindra
IN
Last activity: 27 May 2019 10:01 EDT
How to stop and continue the Forloop after reading specific records
I need to read records from Excel and copy the result back to Excel from application. Due to some time out issue on the application, for every 300 records i have to stop the loop, logout and login back to application and continue the loop. I am giving the initial as 2 for forloop because i have to read from row 2. I gave the row count to the limit of forloop. Now how do I stop the loop after reading every 300 records and continue back from 301 record. The loop initial should start from 301, 601, 901 etc.. after reading every 300 records.
Allied Solutions
US
Tech Mahindra
IN
There might be lakh of records and this screenshot seems to be static. Is there any other way to do it more dynamic?
Pegasystems Inc.
IN
Use loop inside a loop and two automations, to make it totally dynamic.
Inner Forloop: iterates for every 300 records, on completion of this loop, implement your login logic in innerloop automation.
Outer Forloop: Controls how may times inner loop need to be executed. This implementation need to be done at Outerloop automation.
I have attached sample project, which is working at my end(developed in 8.0.2016)
See attached screenshot.
Passing the forloop params as inputs to a single automation will help you "pick up" where you need to with the excel sheet. If you need to do this on different threads, you could always pass your parameters in an activity and just call a new activity after you've ran your sign out/signin logic.