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