Let's now loop through the entire data table variable to input the Excel data to the RPA challenge website:
- Add a Loop action. Choose For each row in table for the Iterator property and excelTable -Table for Table variable, and then create a new Record variable called currentrow:
- Let's now add the variables we will use in automation. Both of these variables will be used as a counter in our loops.
- Create a variable called currentIteration with a Number type. Check both Use as input and Use as output as the variable will be used for both input and output.
- Add another variable called counterstring with a String type, which will also be used for both input and output. counterstring will hold the same value as currentIteration, just with a different type:
- Within the loop, we will start by initializing the counter we just created. we'll shift to List view...