2019.2

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.
Adding fields to an existing Extract step
For optimization purposes, it is better to add fields to an existing Extract step than to have a
succession of extraction steps.
To add fields to an existing Extract step:
1. In the Data Viewer pane, select the data that needs to be extracted. (See "Selecting data"
on the facing page.)
2.
Select an Extract step on the Steps pane.
3.
Right-click on the data and select Add Extract Field, or drag & drop the data on the Data
Model.
When data are dropped on the Data Model, they are by default added to the currently selected
Extract step.
Editing fields
After extracting some data, you may want to:
l
Change the names of fields that are included in the extraction.
l
Change the order in which fields are extracted.
l
Set the data type, data format and default value of each field.
l
Modify the extracted data through a script.
l Delete a field.
All this can be done via the Step properties pane (see "Settings for location-based fields in a
Text file" on page363), because the fields in the Data Model are seen as properties of an
Extract step. See also: "Fields" on page291.
Testing the extraction workflow
The extraction workflow is always performed on the current record in the data source. When an
error is encountered, the extraction workflow stops, and the data field on which the error
Page 257