Filter rows

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:

  • Let values pass (from source table)
  • Block values (from source table)

if

  • all conditions are met
  • one condition is met

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

  • Condition met: If a comparison value is missing, the condition is assumed to be met.
  • Condition not met: If a comparison value is missing, the condition is assumed to not be met.

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.

Topics

Parameters