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) |
| Argument | Required? | Data Type | Description |
|---|---|---|---|
| array_ref1 | Y | string or array | Name of first column or first array literal to apply to the function |
| array_ref2 | Y | string or array | Name of second column or second array literal to apply to the function |
Array literal or name of the array column whose elements you want to combine together.
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | Array literal or column reference | myArray1, myArray2 |
Source:
| Item | Letters | Numerals |
|---|---|---|
| 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:
| Item | Letters | Numerals | LettersAndNumerals |
|---|---|---|---|
| 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"]] |