Testing and validating functions in Transformation Designer

In the Define Function dialog, accessible from Transformation Designer, after adding or importing a function and before adding it to your transformation you should test it and check its validity.

To test and validate a function after adding, or importing it from within the Define Function dialog:

  1. In the TML Details section, click the Define Functions button. The Define Function dialog is displayed.
  2. After adding or importing a function in the Define Function dialog, from the Function name drop-down list select the function you want to test.
  3. Click the Test button. The Function Test dialog is displayed.
  4. Depending on the type of function, enter suitable values against the necessary parameters.
    Note: Commas as decimal separators are not supported. Always use a full stop as a decimal point, or apply a function to transform your numeric values.
  5. Click Run.
  6. Result details are displayed at the bottom of the Function Test dialog.
  7. Click OK to close the Function Test dialog.
  8. In the Define Function dialog, click the Validate button. Error messages are displayed if there are any syntax errors within the function.
  9. Click OK to close the Define Function dialog.

    The function is now ready to be selected for future use.