Creating a transformation

To create a transformation, you must first specify general details about it, including a name and description and whether the transformation is scripted using Transformation Language (TML) or Extensible Scripting Language (XSL).

Complete the General details to view the transformation dialog:

  1. Open Transformation Designer.
  2. Click Create new Transformation.
  3. Complete the General information:
    Script Type
    Select either TML or XSL. When you select XSL, you can only create transformations in Script view using XSL.
    Name
    Specify a name for the new transformation rule. After the rule is created, it can be selected from the list of transformations in Profile Designer.
    Description
    Optionally, specify a description for the new transformation.
    Source Format
    Select a data format for the source. This refers to the data formats available from Format Designer and includes formats that are user defined.
    Target Format
    Select a data format for the target.
    Note: At least one from Source Format and Target Format must be a SunSystems component.
  4. Click Save Profile. Depending on the script type, either the TML Details or the Script view is displayed. For TML scripts, the field-to-field mapping is automatically generated where both the source and target are the same SunSystems data format.
  5. Define the transformation by editing the mapping. To view or edit the transformation source code, click Script view.
    Note: Any source or target data displayed with a grey background is read-ony data.
  6. Validate and test the transformation.
Parent topic: Using Transformation Designer to create data transformations