ZIP
Merges the given arrays, element-wise, into a single array of rows.
Syntax
Arguments
ARRAY
ARRAY
Type: array
A array of values of any type.
Returns
Type: array
The given arrays merged element-wise into a single array of rows.
The M-th element of the N-th argument will be the N-th field of the M-th output element. If the arguments have an uneven length, missing values are filled with NULL
.
Examples
Transformation job example
SQL
Query result
Last updated