2018.2

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 next 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287), because the fields in the Data Model are seen as properties of an
Extract step. See also: "Fields" on page218.
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 field on which the error occurred
and all subsequent fields will be greyed out. Click the Messages tab (next to the Step
properties pane) to see any error messages.
To test the extraction workflow on all records, you can:
Page 184