2018.1

Note
Data format settings tell the DataMapper how certain types of data are formatted in the data
source. They don't determine how these data are formatted in the Data Model or in a template. In
the Data Model, data are converted to the native data type. Dates, for example, are converted to a
DateTime object in the Data Model, and will always be shown as "year-month-day" plus the time
stamp, for example: 2012-04-11 12.00 AM.
l
Negative Sign Before : A negative sign will be displayed before any negative value.
l
Decimal Separator : Set the decimal separator for a numerical value.
l
Thousand Separator: Set the thousand separator for a numerical value.
l
Currency Sign : Set the currency sign for a currency value.
l
Date Format : Set the date format for a date value.
l
Date Language : Set the date language for a date value (ex: If English is selected, the
term May will be identified as the month of May).
l
Treat empty as 0 : A numerical empty value is treated as a 0 value.
Order and rename fields dialog
The Order and rename fields dialog displays the extracted fields in the currently selected
Extract step.
To open it, first select an Extract step on the Steps pane. Then, on the Step properties pane,
under Field Definition, click the Order and Rename Fields button next to the Field List drop-
down.
Field extractions are executed from top to bottom.
In JavaScript-based fields, it is possible to refer to previously extracted fields if they are
extracted higher in this list or in previous Extract steps in the extraction workflow.
Page 277