Setting Conditions Using Expression Builder - trillium_discovery - trillium_quality - 17.1

To set a condition for a rule

1. In the Navigation View, expand the Develop project with which you want to work.
2. Expand Processes.
3. Right-click a process and select Edit Process. The process editing window opens.
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. In the left pane, right-click a condition and select one of the following:
   • Edit... to modify the existing conditional
   • Insert > Condition Before... to add a condition before the current condition
   • Insert > Condition After... to add a condition after the current condition
   • Insert > Sub-condition... to add a sub-condition to the current condition

   The Edit Condition window opens.

7. (Optional) Click Rules Library to use an expression from a rule stored in the Business Rules Library. For information about using library business rules, see Using the Business Rules Library in Quality.
8. In the lower left pane, click Attributes.
9. In the lower right pane, double-click an available attribute.
10. Select the operator by clicking a button in the middle or clicking Operators in the lower pane, then selecting an available operator. See Expression Operators for details of each operator.

    Note the following IF operator guidelines:

    • When using the Expression Builder inside a Quality project, do not select "IF" to specify a condition. The "IF" part of the syntax is always generated in the background.
    • Adding multiple IF operators to the top level of a single conditional section is not supported. Include only one top-level IF (head-if) per section.
    • There are a maximum of 100 nested IFs allowed in IF/ELSE conditional statements.
11. Enter the value after the operator. For example, enter "US" after the equal symbol.
    Note: Literal values must be enclosed with double quotations.
12. Click OK.

    If you inserted a new condition, it is added to the left pane.

    For more information about Transformer Rules, see Creating Conditional Transformation Rules.

To change the order of a condition

1. Open the Input or Output Transformations window.
2. Right-click a condition and select one of the following:
   • Move Up to move the conditional up one position
   • Move Down to Move the conditional down one position
   • Move To Top to move the conditional to the top of the window
   • Move To Bottom to move the conditional to the bottom of the window

   See example:

   In this example, the condition is met if the country code stored in the Country attribute is "US".