2021.2

Extracting data with a script.
The topic: "Extracting data of variable length" on page250 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259).
3. (Optional.) Add an empty detail table via the Data Model pane: right-click the Data Model
and select Add a table. Give the detail table a name.
4. Select the Repeat step on the Steps pane.
5. Start extracting data (see "Adding an extraction" on page232).
When you drag & drop data on the name of a detail table in the Data Model pane, the data
are added to that detail table.
Dropping the data somewhere else on the Data Model pane creates a new detail table,
with a default name that you can change later on (see "Renaming a detail table" on
page313).
Page 240