FILTER

Returns all element in the array for which the lambda returns true.

Syntax 

FILTER(array, LAMBDA(item, [expr]))

Examples 

Example 1

Input

{
  "my_array": [
    1,
    2,
    3,
    4,
    5,
    6,
    7,
    8,
    9,
    10
  ]
}

Formula

FILTER(my_array, LAMBDA(item, item > 5))

Output

[
  6,
  7,
  8,
  9,
  10
]
Was this helpful?