You can set a value or function for input or output attribute transformation using the Expression Builder for the following Quality processes:
- Business Data Parser (input only)
- Decision Point
- File Update
- Set Selection
- Transformer
Note: You can also enter expressions directly in the to expression text box without
using the Expression Builder.
Set a value for an attribute
To set a value for an attribute
Set a function for an attribute
To set a function for an attribute
- Follow Steps 1-9 above.
- Click the Build expression... button () to open the Set Attribute to Expression window.
- Under Choose expression elements from the lists below, in the left pane, click Functions.
- In the right pane, double-click a function. For example, if you select String and then UCASE, the expression UCASE() displays in the expression field. See Expression Builder Functions for details of each function.
- In the expression field, place your cursor in between the parentheses ( ).
- In the lower left pane, click Attributes and then double-click an available attribute. The attribute is inserted into the expression; for example: UCASE([Line 01])
- Click OK.
- Click Finish.
- To set a condition that applies to the rule, right-click the filter in the left pane, and select Edit >Condition... . For more information, see Set a condition using the Expression Builder.