Filtering Input and Output Rows 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 filter the input and output rows for most Quality processes using the Expression Builder. By filtering, you can select and bypass input or output rows for any process. Bypassed rows are not included as input to the dependent processes.

To filter rows

  1. From the Navigation or Project View, right-click a Quality process and select Edit Process.
  2. Do one of the following:
    • Click the Input Settings tab. Input actions are performed on the input rows prior to copying of data to output.
    • Click the Output Settings tab. Output actions are performed on the output rows after copying of data to output.
  3. Click the Build expression... button ( ). The Set Row Filter window displays.
  4. In the left expression elements pane, select Attributes. In the right pan double-click an attribute name. This is the attribute to which you apply the filtering conditions.
  5. Construct a filter expression using the following 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.
    • If you want to filter rows based on the attribute being empty, set the condition to "" (two double quotation marks). Example: [Line 01]=""
    • You can also enter expressions directly in the Row Filter text box without using the Expression Builder.

    See Expression Operators for details of each operator.

  6. Click OK. The expression displays in the Row Filter field.