2021.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 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.
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.
l Tables: Lists all tables and stored queries in the database.
l Custom Query: Displays the query that retrieves information from a database. You may
use variables and properties in the query, to make the selection dynamic. See "Using
variables and properties in an SQL query" on the facing page.
Each database type has their own version of the SQL query language. To learn how to
build your own query, please refer to your database's user manual.
l
Test Query button : Click to test the custom query to ensure it will retrieve the
appropriate information.
l Results: Displays the result of the SQL query when clicking on Test Query.
Page 337