Using the For each row in table iterator

Use the For each row in table iterator in the Loop action to read the data of each row in a table variable and assign the current row to a record variable.

Prerequisites

First, retrieve the table values and store them to a table variable.

To use the For each row in table iterator in a Loop action, do the following:

Procedure

  1. Double-click or drag the Loop action from the Loop package in the Actions palette.
  2. Select the For each row in table option from the Iterator list.
  3. Select the variable that holds the values from the Table variable list.
  4. Select a record variable from the Assign the current row to this variable list or create a new one.
  5. Click Save.

Next steps

Insert actions to use the values from the data table in your automation. Use the record variable to retrieve the values by index number or column name. For example, if the first column of the file is titled EmployeeID, to retrieve the value of the first cell of each row enter $rYourVariableName[0]$ or $rYourVariableName{EmployeeID}$.