Tamr Documentation

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 of a FILTER statement, rows for which the condition is FALSE are dropped 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 the filter() function which removes values from an array. See Map, Filter, and Reduce. Because the syntax for Tamr transformations is case insensitive, Tamr recommends writing statement names in all uppercase and function names in all lowercase as a best practice.

Updated about a year ago



Filter


FILTER retains rows that satisfy a specified Boolean expression (condition).

Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.