2022.1

l Data Format: Data format settings tell the DataMapper how certain types of data are
formatted in the data source. Make sure that this format matches the actual format of the
data in the data source.
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.
XMLand JSON files
l Property: Displays a list of Source Record properties set in the Preprocessor step (see
"Preprocessor step" on page279).
l Type: Displays the type of the Source Record property. Read only field.
l Based on: Determines the origin of the data.
l Location: The contents of the data selection set below will be the value of the
extracted field. The data selection settings are different depending on the data
sample type.
l XPath / JsonPath: The path to the XML field / JSON element that is extracted.
For an overview of XPath functions, see Mozilla: XPath Functions.
Page 382