Use the Filter transformation to filter input data by defining conditions that must be met by records in the input.
Conditions
Logical operator
By default, a record must match all the conditions.
-
Match all of the following conditions (AND) - selects records with values that meet all conditions specified (logical "AND")
-
Match any of the following conditions (OR) - selects records with values that meet at least one of the conditions specified (logical "OR")
-
Match none of the following conditions (NOT) - selects records with values that doesn't meet any of the conditions specified (NOT ( ... OR ... ))
Specifying conditions
Each condition comprises of an expression (or field), a comparison operator , and possibly another value or expression to compare with (depending on the operator).
-
Expression (left-hand) - In the drop-down list on the left, select a field or edit an expression. (You can read more about expressions and functions)
-
Operator - Select the operator from the following list:
Operator |
Description |
text equals |
The expression on the left must be equal to the string value on the right. The text should not be enclosed in quotes or escaped. |
text not equals |
The expression on the left must not be equal to the string value on the right. The text should not be enclosed in quotes or escaped. |
text matches |
The expression on the left must match the regular expression string value on the right. The text should not be enclosed in quotes or escaped. For example, matching a string field with .*dog.* would pass any string that contains the string dog: dog, dogs, adogmatic. |
text is empty |
The expression on the left must be empty. |
text is not empty |
The expression on the left must not be empty. |
= |
The expression on the left must be equal to the expression on the right. |
!= |
The expression on the left must not be equal to the expression on the right. |
> |
The expression on the left must be greater than the expression on the right. |
>= |
The expression on the left must be greater than or equal to the expression on the right. |
< |
The expression on the left must be less than the expression on the right. |
<= |
The expression on the left must be less than or equal to the expression on the right. |
is null |
The expression on the left must be null. |
is not null |
The expression on the left must not be null. |
is true |
The expression on the left must true - especially useful when left hand side is a complex expression. |
-
Value/Expression - with text operators, type the text or pattern to compare to. With other operators, pick a field or edit an expression.