Let's now iterate through each of the columns in the row. We will associate each column with the corresponding header in Excel. These columns will then be mapped to the input fields on the RPA challenge website.
We will use the If condition and a series of Else If conditions to map the iteration counter to the headers, for example, Counter#1 to First Name, and Counter#2 to Last Name. Let's follow these steps to do that:
- We will start by adding the If action. We will check whether it is the first column that has counterstring as 1. To indicate that, let's set the properties as follows:
- Condition: String condition
- Source value: counterstring
- Operator: =
- Target value: 1
This should look like the following screenshot:
- Next, let's indicate that the first column at position 1 is First Name. To do that, add a String Assign action under the If...