2020.1

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 "Extract step properties" on page333),
because the fields in the Data Model are seen as properties of an Extract step. See also:
"Fields" on page263.
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
occurred and all data fields related to subsequent steps 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 that are displayed, you can either:
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.
Note
How many records are displayed in the Data Viewer (200, by default) is specified in the Record
limit on the Settings pane.
Selecting data
In order to extract the data, it is necessary to first define the data to be extracted, by selecting it.
How this is done depends on the data source type. The following paragraphs explain how to
create and manipulate a data selection for each different type of data.
Data selections are used to extract promotional data ("Extracting data" on page225),
transactional data ("Extracting transactional data" on page231) and to apply a condition to an
Page 229