Filters the data feed one row at a time using specific conditions.
Column values of the Number, Text, or Date type are either let passed or blocked. An appropriate filter criterion can be selected depending on the data type.
The operator allows the processing of single values and value lists. You can connect the single-value user inputs and the user inputs of List type, see User input operators.
Action |
Result |
Action |
Executed if particular conditions are met. Possible actions:
if
Default value: Let values pass if all conditions are met. Specification: Mandatory |
Column |
Name of the column whose values are filtered. Source: Source table Data type: Number, Text, Date; Specification: Mandatory |
Comparison operator |
Operator that compares the values from the source column with the comparison values. Available comparison operators depend on the data type of the source column. Default value: is equal to Specification: Mandatory |
Comparison values |
Values that are compared with the values from the source column. Source: Source table, single-value operator, user input, user input (List), or a constant Data type: Must be identical to that of the source column. Comparison value missing
Specification: Mandatory |
All conditions should match. |
Combines the specified filter conditions. If the option is not enabled, the result will be a concatenation of all single filter results. |
The following parameters are available.
Parameter |
Description |
---|---|
Number |
Is equal to Is not equal to Is less than Is less than or equal to Is greater than Is greater than or equal to Is empty Is not empty |
Text |
Is equal to Is not equal to Starts with Ends with Contains Does not contain Is empty Is not empty |
Date |
Before After In Before or on On or after Is empty Is not empty |
Comparison operators processing value lists
If a value list is processed (that is, the comparison value is a value list), either
all filter values (ALL) or just a few filter values (ANY) can be applied for the filter
condition (see table below). Click the () Operator condition icon to view the settings. The settings are also displayed in the tool tip.
For filter conditions using the comparison operators is equal to, starts with, ends with, contains, and on the predefined applied list values are set to ANY.
For filter conditions using the comparison operators is not equal to, does not contain, is less than, is greater than, and after the predefined applied list values are set to ALL.
The setting of the applied filter values can be changed for all comparison operators
except is equal to, is not equal to, and on. Click the () Operator condition icon and select the settings required.