2020.2

Special conditions
The Extract step may need to be combined with another type of step to get the desired result.
l
Data can be extracted conditionally with a Condition step or Multiple Conditions step;
see "Condition step" on page254 or "Multiple Conditions step" on page257.
l Normally the same extraction workflow is automatically applied to all records in the
source data. It is however possible to skip records, entirely or partially, or to stop data
mapping using an Action step. Add an Action step in a branch under a Condition step or
Multiple Conditions step (see "Action step" on page258) and set the type of action to
Stop processing recordor Stop data mapping, according to what is needed (see "Action
step properties" on page344).
l
To extract transactional data, the Extract step must be placed inside a Repeat step. See
"Extracting transactional data" on page235.
Note
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.
Extracting data into multiple fields
When you select multiple fields in a CSV or tabular data file and extract them simultaneously,
they are put into different fields in the Data Model automatically.
In a PDF or Text file, when multiple lines are extracted at the same time, they are by default
joined and put into one field in the Data Model. To split them and put the data into different
fields:
1. Select the field in the Data Model that contains the extracted lines.
2.
On the Step properties pane, under Field Definition, click the drop-down next to Split
and select Split lines.
Page 231