2018.2

Adding an Extract step
To add an Extract step, first select the step on the Steps pane after which to insert the Extract
step. Then:
l
In the Data Viewer, select some data, right-click that data and choose Add Extraction, or
drag & drop the data in the Data Model. For more detailed information and instructions,
see: "Extracting data" on page181.
l
Alternatively, right-click the Steps pane and select Add a Step > Add Extraction. Make
the required settings on the Step properties pane.
If an Extract step is added within a Repeat step, the extracted data are added to a detail table
by default; see "Extracting transactional data" on page186 and "Example " on page260.
Configuring an Extract step
The names, order, data type and default value of the fields extracted in an Extract step are
properties of that Extract step. These and other properties can be edited via the Step properties
pane. For an explanation of all the options, see "Settings for location-based fields in a Text file"
on page287.
Data cannot be extracted more than once in any record, unless the Extract steps are mutually
exclusive. This is the case when they are located in different branches of a Condition step or
Multiple Conditions step.
Inside a Detail table, multiple Extract steps may extract the same data but each of them will
create a new child record in the Detail table.
If you tick the Append values to current record option when several steps are extracting the
same field, the step will error out.
Repeat step
The Repeat step is a loop that may run 0 or more times, depending on the condition specified.
It is used for the extraction of transactional data; see "Extracting transactional data" on
page186.
Repeat steps do not automatically move the pointer in the source file. Therefore a Goto step
that moves the cursor is added automatically within the loop to avoid an infinite loop, except in
Page 205