FILTER

Returns a filtered version of the source frame, returning only rows or columns which meet the specified conditions.

Syntax

FILTER(targetFrame, searchExpr)

• targetFrame - Target Frame.

• searchExpr - Search Expression.

Sample Usage

FILTER(C1, "@number = 2")
FILTER(C1, D1)

Return Value

• Returns extracted value or frame.

Notes

In order for FILTER to work, the first argument targetFrame must be a FRAME.

See Also