Data Transformations

When configuring the data map for an Import Definition, you can optionally apply a data transformation to a field in the import file. The platform supports the following Data Transformations.

Format Transformations

• Case: Change the case of the value in this field to:

• All upper case

• All lower case

• Proper Case (proper case is any text that is written with each of the first letters of every word being capitalized)

• Numeric: Change the value in this field to:

• Integer

• Decimal

• Boolean: Change the value in this field to a Boolean value.

• Date: Format the value in this field using the select date / time format option.

• Currency: Format the value in this field using the select currency option. To use this option, the "Contains Unescaped Double Quotes" option on the Origin Settings screen must be set to No.

Structure Transformations

• Merge: Combine the value in this field with the value in one or more additional specified fields. Select the character to separate the values in the different fields (a space or a comma).

• Split: Split the value in this field into one or more selected destination fields. Select the character that identifies where to perform the split (a space, a comma, or a semi-colon).

• Substring: Load only a selected portion of the value in this field. Enter the start position and length of the portion that you wish to load.

Change Transformations

• Lookup: Select the desired Lookup table, the field to match against, the value to use if a match is found, and the value to use if no match is found.

• Replace: Select the desired Lookup table, the field to match against, the value to use if a match is found, and whether or not you want to accept null values.

Advance Transformations

• Groovy: Enter a Groovy expression.