2022.1

default format values for any newly created data mapping configuration.
Format settings can also be defined at the data mapping configuration level ("Data mapping
configurations" on page222) and/or per field in the Data Model. Any format settings specified in
an existing field are always used, regardless of the user preferences or data source settings.
l Negative Sign Before: Any value in a numeric field that has a "-" sign is interpreted as a
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 Automatic: Select this option to parse dates automatically, without specifying a
format. This is the default setting for new Date fields.
l ISO8601: This setting allows for dates with different timestamp formats, or belonging
to different time zones, to be parsed inside a single job. Dates that do not include a
specific time are automatically considered to use the current locale's time zone.
Select the ISO template to be used when parsing the timestamp. Other ISO8601
formats can be handled via the Custom option.
l Custom: Set a custom date format. For the markers available in the DataMapper
see "Defining a date/time format" on page314.
l Language: Set the language for a date value (ex: If English is selected, the term May will
be identified as the month of May).
l Use offset from UTC: Select the default time zone, which is to be used to extract any
timestamp that does not already include time zone information with the time.
l Treat empty as 0: A numerical empty value is treated as a 0 value.
In the Data Model, time stamps can be:
l Displayed in Local Time: The time is formatted in accordance with the current operating
system's regional settings.
l Displayed as UTC/ISO: The time is displayed in UTC (Coordinated Universal Time)
following ISO 8601.
Note that this setting only impacts how dates are displayed in the Data Model. It does not
change how dates are stored in the Connect database, nor how they are displayed in a
template.
The DataMapper preferences also provides you with buttons to :
Page 894