Setting Attributes Using Expression Builder - trillium_discovery - trillium_quality - 17.1

To set a value for an attribute

1. In the Navigation View, expand the Quality project with which you want to work.
2. Expand Processes.
3. Right-click the process and select Edit Process. The process editing window displays.
4. Do one of the following, depending on the type of attributes you want to set:
   • Click the Input Conditionals tab.
   • Click the Output Conditionals tab.

   The Input or Output Transformations window displays.

5. In the Select Input or Select Output drop-down list, select the name of the input or output data file.
6. Right-click in the Transformation window and select Add > New > Attribute Transformation. The Set Attribute window displays.
7. Enter a description in the Description field.
8. Click the Set Attribute drop-down list and select an attribute you want to transform.
9. Do one of the following:
   • In the to expression box, enter the value.
   • Click the Build expression... button () to open the Set Attribute to Expression window and enter the value in the upper pane. Click OK.
   Note: Literal values must be enclosed with double quotations.
10. Click Finish. The transformed attribute displays in the right window. To make edits or deletions, right-click the row and select Edit... or Delete.
11. To set a condition that applies to the rule, right-click the conditional in the left pane, and select Edit. For more information, see Set a condition using the Expression Builder.

    See example:

    In this example, you want the literal "Invalid" to be placed in the attribute you selected.

    

To set a function for an attribute 

1. Follow Steps 1-9 above.
2. Click the Build expression... button () to open the Set Attribute to Expression window.
3. Under Choose expression elements from the lists below, in the left pane, click Functions.
4. 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.
5. In the expression field, place your cursor in between the parentheses ( ). 
6. 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])
7. Click OK.
8. Click Finish.
9. 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.