Page tree

 

Support | BlogContact Us | 844.332.2821

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc

Excerpt

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.

D s
snippetBasic

Array literal reference example:

D code

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

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

Column reference example:

D code

derive 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

D s
snippetSyntax

D code

derive 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

d-s-lang-notes

array_ref1, array_ref2

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

D s
snippetusage

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

D s
snippetExamples

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:

D code

derive 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

Include Page
EXAMPLE - Flatten and Unnest Transforms
EXAMPLE - Flatten and Unnest Transforms

D s also
labelnested