2022.1

Tip
The default extraction method for fields in a CSV or XLS(X) file is data.extract
(columnName, rowOffset). Changing the expression to use the
data.extractByIndex(index, rowOffset) method will allow the data mapping
configuration to extract data from files that have the same structure, but different column
names.
Property-based field
A property-based field is filled with the value of a property (see "Properties and runtime
parameters" on page253).
Custom properties can be added via the Preprocessor step; see "Preprocessor step" on
page279.
A property-based field cannot be added directly. To fill a field with the value of a property, you
have to change an existing field's Mode to Properties.
1. Select the field in the Data Model.
2. On the Step properties pane, under Field Definition, change its Mode to Properties.
3. Select the property from the Property drop-down list, or click the button to the right, to
open a filter dialog that lets you find a property based on the first few letters that you type.
Another way to add the value of a property to a field is by setting the field's Mode to JavaScript
and entering the corresponding property in the Expression field, e.g.
data.properties.myProperty;.
Adding empty fields via the Data Model pane
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, detail
table or group. A field will be added with no extraction, while a detail table will be added with
no fields inside.
Here's how you can fill the field with data.
Page 298