Filter Row If True directive (deprecated)

The FILTER-ROW-IF-TRUE directive filters records that match a condition.

Deprecated

Use the FILTER-ROWS-ON directive instead.

Syntax

filter-row-if-true <condition>

The <condition> is a valid boolean expression resulting in either a true or false.

Usage Notes

The FILTER-ROW-IF-TRUE directive evaluates the Boolean condition for each record. If the result of evaluation is true, it skips the record, otherwise it is passed as-is to the input of the next directive.

The <condition> is specified in the JEXL expression language with additional utility libraries are defined in the math and string namespaces.

For information on how to write JEXL expressions, see the commons-jexl documentation.

Examples

Using this record as an example:

{ "id": 1, "name": "Joltie, Root", "hrlywage": "12.34", "gender": "Male", "country": "US" }

Applying this directive:

filter-row-if-true country !~ US

would result in filtering out records for individuals that are not in the US (where country does not match "US").

Applying this directive:

would result in filtering out records for individuals that are not in the US (where country does not match "US") and whose hourly wage (hrlywage) is greater than 12.

Created in 2020 by Google Inc.