1.8

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221), because the fields in the Data Model are seen as properties of an
Extract step. See also: "Fields" on page155.
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:
l
Click the Validate All Records toolbar button.
l
Select Data > Validate Records in the menu.
If any errors are encountered in one or more records, an error message will be displayed. Errors
encountered while performing the extraction workflow on the current record will also be visible
on the Messages tab.
Selecting data
In order to extract the data, it is necessary to first define the data to be extracted, by selecting it.
It depends on the data source file type how this is done. The following paragraphs explain how
to create and manipulate a data selection in each different type of file.
Data selections are used to extract promotional data ("Extracting data" on page118),
transactional data ("Extracting transactional data" on page124) and to apply a condition to an
extraction (Condition step).
Page 122