Input and Output Conditionals for Set Selection - 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

The Set Selection utility is designed to manage sets of records on input, and single records on output. This allows you to flag values throughout the set based on conditional results and then investigate individual records on the output. You can add an Attribute Transformation or insert a condition for attributes in the input and output data.

Note the following:

  • The Set Selection utility only processes records when the conditions are met, although you can run the utility without setting a condition.
  • The Set Selection Aggregate functions (ALL, ANY, AVG, NUM, SUM) work on sets only, and therefore are not available for output conditionals. They are also not supported for input and output row filters.

Add an Attribute Transformation to the Set Selection utility

To add an Attribute Transformation to the Set Selection utility

  1. From the Navigation or Project View, right-click the Set Selection process and select Edit Process. The process editing window opens.
  2. Select the Input Conditionals or Output Conditionals menu option.
  3. Right-click in the right window and select Add> New >Attribute Transformation. The Set Attribute window opens.
  4. In the Description field, enter a description of the condition you are defining.
  5. From the Set Attribute list box, select the name of the attribute you want to conditionalize.
  6. Click the icon to the right of the To expression field. The Expression Builder window opens. See Setting Conditions Using Expression Builder for information on how to build conditional expressions. For information about using Set Selection functions for input conditionals, see Expression Builder Functions for Sets of Records.
  7. After you build your expression, click Finish.
  8. Repeat Steps 3 through 7 to define another condition.

Insert a condition to the Set Selection utility

To insert a condition to the Set Selection utility

  1. From the Navigation or Project View, right-click the Set Selection process and select Edit Process. The process editing window opens.
  2. Select the Input Conditionals or Output Conditionals menu option.
  3. Right-click in the left window right-click a condition and select one of the following:
    • 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 expression builder opens. See Setting Conditions Using Expression Builder for information on how to build conditional expressions. For information about using Set Selection functions for input conditionals, see Expression Builder Functions for Sets of Records.

  4. After you build your expression, click Finish.
  5. Repeat Steps 3 through 5 to define another condition.