Groovy Filter
This task allows the user to filter data selectively based upon a Groovy expression.
| OPTION | DESCRIPTION |
|---|---|
| INCLUDE/EXCLUDE | Determines if we are including/excluding data based upon the filter match. |
| IF/UNLESS | Determines if we are including/excluding based on its condition being true "IF" or the condition being false "UNLESS". |
Expressions can be as complex as needed but must evaluate to a true or false condition.
INPUT
No special requirements.
OUTPUT
Only rows matching the condition are output to the data.
EXAMPLES
INCLUDE-IF
Including rows where the president's home state is Ohio.
EXCLUDE IF
Excluding rows where the president's home state is Ohio. Equivalent to INCLUDE-UNLESS.
EXCLUDE-UNLESS
Excluding rows unless the president's home state is Ohio. Equivalent to INCLUDE-IF.
