You can configure expressions when the output format is relational or hierarchical. For flattened output, the expression is fixed to the default format once you add the field and configuration is not possible.
To configure an expression in the Hierarchy Processor transformation, follow these steps:
Perform one of the following actions to create the output fields:
To use an incoming field as an output, click the
link that appears when you hover over the incoming field.
To create a new field, click
in the Output Fields panel near the output group name or near an array name.
Click the expression in the Output Fields section.
For newly created fields, the link appears as
dialog box appears.
Enter the expression in the expression editor. You can add incoming fields, functions, and variables to the expression by clicking the
link next to the object that you want to use. You can also type in the expression manually.
The expression can contain constants, variables, built-in functions, and user-defined functions. You can nest functions to create a complex expression.
If you modify the references to any of the fields, your expression will fail.
Correct any errors.
You can close the editor and troubleshoot an invalid expression at another time.