Transformer Options page

Use the Transformer stage to perform common data transformations.

When you add a Transformer stage to your flow and double-click the stage icon, you will see the Transformer Options page. The Transformer Options page is a workspace that allows you to construct transforms from a variety of functions that come with Flow Designer. This page consists of a palette on the left side, a scripting workspace, and Apply and Cancel buttons.
Table 1. Fields and settings on the Transformer Options page
Field or setting Description Options
Field and function display This drop-down, at the top left of the page, displays all field and function options, or filters the display based on your selection. Select the fields and functions to display:
  • All (no filtering) - Display all fields and functions
  • Input - Display all available input fields for the current input file
  • Output - Display all Output fields resulting from the current flow
  • Function - Display all available processing functions based on flow input and output
Filter entry field For the selection in the Field and function display, apply a filter to narrow the fields or functions displayed.

Click X in this field to clear the filtering and display all items in the category you selected in the Field and function display.

 Enter a character or string to use for filtering the display.

For example, if you chose Input in the Field and function display, then type "addr" in the filter entry field, the display might show "AddressLine1" and "AddressLine2".
Input fields Use the arrow to expand and collapse the list of input fields available to process using a custom transform.
  • Name - Field name
  • Type - Field data type
  • List - Select a field to use in a List transform.
Output fields Use the arrow to expand and collapse the list of output fields to process using a custom transform.

To add a field:

  1. Click NEW to display a new row and input field.
  2. Add the new field name; for example, "OutputAddr1".
  3. Click the content of the Type field to apply the field format.
  4. Check the List selection box to include this field in output transform processing.
  • Name - Field name
  • Type - Field data type
  • List - Select a field to use in a List transform.
You can click the trash can next to any output field to delete it.
Functions Use the arrow to expand and collapse the list of functions. You can expand any function parent category to see the functions available under it.

Hover over any function in an expanded category to see a description of the function, a list of applicable parameters, and a description of the data returned.

For any selected field, double-click a function to add it to the scripting workspace.

 The function categories are:
  • DateTime - Processes data to derive a DATETIME object using INT64 values representing the year, month, day, hour, minute, and second.
  • Math - Performs mathematical/trigonometric calculations.
  • String - Performs processing on a defined data string producing a non-numerical result.
  • Miscellaneous - Includes random, roundTo, truncate, and truncateTo functions.
Scripting workspace This is the area where you will construct your data transformation scenarios. For any selected field, double-click a function to add it to the scripting workspace.
Apply and Cancel buttons Save or discard your data transformation.
  • Apply - Apply the function/transformation definition to the selected field.
  • Cancel - Discard the transformation scenario for the selected field.