2022.1

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.
Note
Default data formats 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.
SQL Query Designer
The SQL Query Designer is used to design a custom SQL query to pull information from a
database. It can be opened by clicking the Custom SQL button on the Settings pane, under
Input Data.
Page 361