Defining a TML transformation

Open Transformation Designer.

Select an existing TML transformation and click Edit Transformation. Or, click Create new Transformation and specify the Script Type as TML. The transformation mapping details are displayed in the TML details dialog.

To view or edit the transformation source code, click Script view.

Note: Any source or target data displayed with a grey background is read-only data.

Select a line and click Operation to transform your data:

Assign To: Specify a string or numeric value as the target data element.
Undefined: Specify that the data element is not mapped.
Map: Select one or more source data elements to map to a single target data element.
Function: Use a function to transform the data.
Lookup: Use a lookup table to define a list of transformed output values that are dependent on ranges of source data.
Full Structure: Select to display the full hierarchical structure of the source/target data. The source and target data elements are listed in the TML Details grid along with the assorted transformation operations. Any values displayed in red are invalid and must be corrected.; Hover the mouse over the data element name to display its full hierarchy path.
Hide Direct Mappings: Select to hide data elements that are directly mapped.

Click Save Profile to save your transformation.

Validate and test the transformation.