1.7

When data are dropped on the Data Model, they are by default added to the last added 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 "Text File" on page193), because the
fields in the Data Model are seen as properties of an Extract step. See also: "Fields" on
page129.
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.
Page 99