2022.1

Table Of Contents
Tip
To break out of a loop and immediately jump to the next task following the current loop,
use an Action task and set its action to Break out of repeat loop.
Note that such loops work well when the data are structured uniformly, e.g. when all rows have
the same number of columns, and when detail data always start at the same point in the line.
Obviously, that is not always the case.
How to extract transactional data that is structured differently is explained in another topic:
Extracting data with a script.
The topic: "Extracting data of variable length" on page275 explains a few ways to extract data
from a variable number of lines into one data field.
From a CSV file or a Database
The transactional data (also called line items) appear in multiple rows.
1. Select a field in the column that contains the first line item information.
2. Right-click this data selection and select Add Repeat.
This adds a Repeat step with a GoTo step inside it. The GoTo step moves the cursor
down to the next line, until there are no more lines (see "Goto step" on page283).
Page 265