Filtering Input and Output Rows Using Expression Builder - trillium_discovery - trillium_quality - 17.1

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

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.