ArrayIf

Creates an array from the values in the column filtered by the condition

ArrayIf(column2, StartsWith(column2, "M")) → ["Milk", "Macaroni",..]
ArrayIf(column1, column1 =="[1]") → ["[1]","[1]"]

Inputs

ArrayIf(column, [condition])

  • column - A column to create an array from

  • [condition] - [optional] - Condition to filter values in the column