Last updated 7 months ago
Creates an array from the values in the column filtered by the condition
ArrayIf(column, [condition])
column - A column to create an array from
column
[condition] - [optional] - Condition to filter values in the column
[condition]
ArrayIf(column2, StartsWith(column2, "M")) → ["Milk", "Macaroni",..] ArrayIf(column1, column1 =="[1]") → ["[1]","[1]"]