FILTER
Returns a table that has been filtered.
Syntax
FILTER(<table>, <filter>)
| Parameter | Type | Description |
|---|---|---|
| table | Table | The table to be filtered. |
| filter | Boolean | A boolean (True/False) expression that is to be evaluated for each row of the table. |
Return values
Table
Examples
FILTER(orders, orders.discount == 0)
FILTER(customers, ISEMPTY(customers.last_ordered_at))