Setting Attributes Using Expression Builder - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

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

  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.

Set a function for an attribute

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.