Defining a TML transformation

Define a TML transformation:

  1. Open Transformation Designer.
  2. 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.
  3. 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
    Usee a function to transform the data.
    Lookup
    Use a lookup table to define a list of transformed output values that are dependant 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.
  4. Click Save Profile to save your transformation.
  5. Validate and test the transformation.