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. |