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.

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) Operator condition icon to view the settings. The settings are also displayed in the tool tip.