ToArray

Converts value to the array type

ToArray("[1, 2, 3]") → [1, 2, 3]

Inputs

ToArray(value, [replaceInvalidWith])

• value - A column to convert into an array

• [replaceInvalidWith] - [optional: null by default**]** - invalid values will be replaced with this parameter

Description

We do not have a direct syntax in our expressions to create an Array, but you can get it as a result of some nodes or functions, such as Split or Nest

Convert String columns to Array before using them in the Unnest node.