Data Transformation Table Fields

Here is a description of the fields that make up a data transformation table.

Key: * – Mandatory field. The number indicates the number of characters that are allowed in this text field, where appropriate.

Field     Description
Data Transformation Table Name * 80 The name of the data transformation table.
Description   255 Description of the transformation tables.

Data Transformation Fields

Here is a description of the fields that make up a data transformation.

Field     Description
Data Transformation Table *   The data transformation table using the data transformation entry.
Source Value 1   255 A source value describing the data to be transformed. This value is case sensitive.
Source Value 2   255 An optional secondary value to modify the conditions for transforming the source data. This value is case sensitive.
Target Value   255 The transformed data value, created if the criteria specified in the source values are met.