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

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.

   See example:

   In this example, [Line 01] < 18 indicates that only rows in which the value in the attribute Line 01 is less than 18 will be included and selected for further processing.