Filter
FILTER
retains rows that satisfy a specified Boolean expression (condition).
FILTER
statements typically use logical comparators to find values that do, and do not, meet certain criteria. In this example, the FILTER
statement drops rows for which the condition is FALSE from the dataset.
Example | Syntax Template |
---|---|
FILTER Age > 25 | FILTER <myUA1> <condition> |
This transformation retains the same schema in the output table as in the input.
Important:
FILTER
statements remove rows from a dataset, in contrast to thefilter()
function which removes values from an array. See Map, Filter, and Reduce. Because the syntax for transformations is case insensitive, Tamr recommends writing statement names in all uppercase and function names in all lowercase as a best practice.
Updated almost 3 years ago