2019.1

Fields
Extracted data are stored in fields in the Data Model (see "The Data Model" on page269).
Fields can be present on different levels: on the record level or in a detail table (see "Example "
on page319).
They can be moved up or down and put in groups (see below).
Fields with data belong to an Extract step and are accessible via the Step Properties pane (see
"Settings for location-based fields in a Text file" on page346).
Location-based fields always contain extracted data: they read data from a certain location in
the data source.
Other fields may contain the result of a JavaScript (JavaScript-based fields) or the value of a
property (property-based fields).
Adding fields
Location-based field
Generally location-based fields are added to a Data Model by extracting data; see "Extracting
data" on page238. Location-based fields in detail tables are created by extracting
transactional data; see "Extracting transactional data" on page244.
Alternatively, you can add fields and detail tables directly in the Data Model pane. Right-click
anywhere on the Data Model and a contextual menu will appear. Which menu items are
available depends on where you've clicked. If you right-click inside the record itself, you can
add a field, detal table or group. A field will be added with no extraction, while a detail table will
be added with no fields inside.
After adding a field or detail table this way, you can drag & drop data into it. Without data it is
not accessible via the Step properties pane.
JavaScript-based field
JavaScript-based fields are filled by a script: the script provides a value. Note that the last value
attribution to a variable is the one used as the result of the expression.
There is a number of ways to add a Javascript based field.
Page 275