Combines multiple arrays into a single nested array, with element 1 of array 1 paired with element 2 of array 2 and so on. Arrays are expressed as column names or as array literals.

If the arrays are of different length, then null values are inserted for combinations where one array is missing a corresponding value.

Array literal reference example:

derive type:single value:ARRAYZIP([["A","B","C"],["1","2","3"]] )

Output: Generates a nested array combining elements from the two source arrays.

Column reference example:

derive type:single value:ARRAYZIP([array1,array2]) as:'zippedArray'

Output: Generates a new zippedArray column containing a single nested array pairing the elements of the array in the listed order of the arrays .

derive type:single value:ARRAYZIP(array_ref1,array_ref2)

ArgumentRequired?Data TypeDescription
array_ref1Ystring or arrayName of first column or first array literal to apply to the function
array_ref2Ystring or arrayName of second column or second array literal to apply to the function

array_ref1, array_ref2

Array literal or name of the array column whose elements you want to combine together.

Required?Data TypeExample Value
YesArray literal or column referencemyArray1, myArray2

Example - Simple ARRAYZIP example

Source:

ItemLettersNumerals
Item1["A","B","C"]["1","2","3"]
Item2["D","E","F"]["4","5","6"]
Item3["G","H","I"]["7","8","9"]

Transform:

derive type:single value:ARRAYZIP([Letters,Numerals]) as:'LettersAndNumerals'

Results:

ItemLettersNumeralsLettersAndNumerals
Item1["A","B","C"]["1","2","3"][["A","1"],["B",2"],["C","3"]]
Item2["D","E","F"]["4","5","6"][["F","4"],["G",5"],["H","6"]]
Item3["G","H","I"]["7","8","9"][["G","7"],["H",8"],["I","9"]]

Example - Unnest an array