Different countries use different symbols to separate the integer part from the fractional part of a number and to separate fields in data. For example, you might use a comma instead of a period to separate the integer part from the fractional part of numbers. And, rather than using commas to separate fields in your data, you might use colons or tabs. With a Data Asset import or export node, you can specify these symbols and other options. Double-click the node to open its properties and specify data formats as desired.

Variable names. Select a method of handling variable names and labels upon import from an SPSS Statistics .sav file. Metadata that you choose to include here persists throughout your work inSPSS Modeler and may be exported again for use in IBM SPSS Statistics.

• Read names and labels. Select to read both variable names and labels into SPSS Modeler. This is the default option, and variable names are displayed in the Type node. Labels may be displayed in charts, model browsers, and other types of output. By default, the display of labels in output is disabled.
• Read labels as names. Select to read the descriptive variable labels from the SPSS Statistics .sav file rather than the short field names, and use these labels as variable names in SPSS Modeler.

Values. Select a method of handling values and labels upon import from an SPSS Statistics .sav file. Metadata that you choose to include here persists throughout your work in SPSS Modeler and may be exported again for use in SPSS Statistics.

• Read data and labels. Select to read both actual values and value labels into SPSS Modeler. This is the default option, and values themselves are displayed in the Type node. Value labels may be displayed in the Expression Builder, charts, model browsers, and other types of output.
• Read labels as data. Select if you want to use the value labels from the .sav file rather than the numerical or symbolic codes used to represent the values. For example, selecting this option for data with a gender field whose values of 1 and 2 actually represent male and female, respectively, will convert the field to a string and import male and female as the actual values.

  It's important to consider missing values in your SPSS Statistics data before selecting this option. For example, if a numeric field uses labels only for missing values (0 = No Answer, –99 = Unknown), then selecting the Read labels as data option will import only the value labels No Answer and Unknown and will convert the field to a string. In such cases, you should import the values themselves and set missing values in a Type node.

In the Data Asset import node properties, under Mode, you can select SQL Query if you want to use custom SQL to import data from a database. Use a SQL SELECT statement to pull in rows or columns of data from a database. Note that the Source path field doesn't apply if you're using the SQL Query mode.

The following example pulls in certain rows of data from a database table:

select * from GOSALES.ORDER_DETAILS
where  UNIT_COST > 40,000 LIMIT 4

And this example pulls in certain columns of data from a database table:

select QUANTITY, UNIT_COST, UNIT_PRICE from GOSALES.ORDER_DETAILS

Note that the SQL syntax you use can vary depending on database platform. For example, if pulling in data from an Informix database, Informix requires field names to be surround by double quotes. For example:

select "Age", "Sex" from testuser.canvas_drug

The following databases currently support this custom SQL feature:

• Amazon Redshift
• Apache Hive
• Cloudera Impala
• Compose for PostgreSQL
• Db2 on Cloud
• Db2 Warehouse
• Google BigQuery
• Informix
• Microsoft SQL Server
• MySQL
• Netezza
• Oracle
• Pivotal Greenplum
• Salesforce.com
• Snowflake
• SAP ASE
• SAP IQ
• Teradata