MashZone NextGen 10.2 | Appendix | Operators | Data transformation operators | Filter rows | Behavior
 
Behavior
Filters the data feed one row at a time using particular 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.
Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release