...
If the arrays are of different length, then null values are inserted for combinations where one array is missing a corresponding value.
| D s |
|---|
| D s | ||
|---|---|---|
|
Array literal reference example:
| d-code-lang-syntax | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ARRAYZIP
| |||||||||
arrayzip([["A","B","C"],["1","2","3"]] ) |
Output: Generates Returns a nested array combining elements from the two source arrays.
Column reference example:
| d-code-lang-syntax | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ARRAYZIP
| |||||||||
arrayzip([array1,array2]) |
Output: Generates a new zippedArray column containing a Returns a single nested array pairing the elements of the array in the listed order of the arrays.
| D s | ||
|---|---|---|
|
| d-codelang-syntax | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ARRAYZIP
| |||||||||
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 |
| D s lang notes |
|---|
array_ref1, array_ref2
...
| D s | ||
|---|---|---|
|
Example - Simple ARRAYZIP exampleARRAYZIP example
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"] |
TransformTransformation:
d-
...
trans RawWrangle true p03Value 'LettersAndNumerals' Type step WrangleText derive type:single value:
...
arrayzip([Letters,Numerals]) as:'LettersAndNumerals' p01Name Formula type p01Value Single row formula p02Name Formula p02Value arrayzip([Letters,Numerals]) p03Name New column name SearchTerm New formula
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"]] |
...
Include Page EXAMPLE - Flatten and Unnest Transforms EXAMPLE - Flatten and Unnest Transforms
D s also label nested
