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