Function sequence

The function sequence pane of the  Development Studio Basic transform editor contains the actions to be performed by the transform. You select the functions and their sequence to transform the data.

The function sequence pane sets the actions and the order they execute to transform the data. The function sequence contains String, XML, Logical, Math, and Date and Time functions. You can expand and collapse the functions by double-clicking the folder name. Additional fields appear based on the function selected.

This example shows how to use the transform editor as part of an assign activity. For this scenario, a process was created with an Assign activity.

To use the Basic transform editor to convert an epoch date to an EU date format

1. Double-click the Assign activity to display its property panel.

2. Click the Add button and add an assign statement that is a date as follows:

   1. Select date from the Parameter Type list.

   2. Select the date to use as the input parameter.

3. Choose the output parameter context type as follows:
   1. Create a context item called date.
   2. Click Select to use the context item.

   3. Click OK to accept the parameters.

4. Create another assign statement that is a context item using the output from the first statement to format the date (the context item date).

5. Click OK.

6. On the property panel, click Basic to use the Basic transform editor.
7. In the Function Sequence section window, select Date and Time Function from the Function list.
8. Expand Date Function and select EU date (format).
9. In the Function Sequence section, select Operand Date/time (Exact).
10. Click OK.
11. Assign the output to a new context item as follows:
    1. Click Output Context type Context Item.
    2. Click New and then create a context item named formatted date.
    3. Select the formatted date context item.
12. Click OK to finish the assign statement.
13. Press Ctrl+S to save the process.