Skip to main content

# EXAMPLE - Nested Functions

This example illustrates how to use the nested functions.

Functions:

Item

Description

ARRAYCONCAT Function

Combines the elements of one array with another, listing all elements of the first array before listing all elements of the second array.

ARRAYINTERSECT Function

Generates an array containing all elements that appear in multiple input arrays, referenced as column names or array literals.

ARRAYCROSS Function

Generates a nested array containing the cross-product of all elements in two or more arrays.

ARRAYUNIQUE Function

Generates an array of all unique elements among one or more arrays.

Source:

Code formatting has been applied to improve legibility.

Item

ArrayA

ArrayB

Item1

["A","B","C"]
["1","2","3"]

Item2

["A","B"]
["A","B","C"]

Item3

["D","E","F"]
["4","5","6"]

Transformation:

You can apply the following transforms in the following order. Note that the column names must be different from the transform name, which is a reserved word.

 Transformation Name New formula Single row formula ARRAYCONCAT([Letters,Numerals]) 'concat2'
 Transformation Name New formula Single row formula ARRAYINTERSECT([Letters,Numerals]) 'intersection2'
 Transformation Name New formula Single row formula ARRAYCROSS([Letters,Numerals]) 'cross2'
 Transformation Name New formula Single row formula ARRAYUNIQUE([Letters,Numerals]) 'unique2'

Results:

For display purposes, the results table has been broken down into three separate sets of columns.

Column set 1:

Item

ArrayA

ArrayB

concat2

intersection2

Item1

["A","B","C"]

["1","2","3"]
["A","B","C","1","2","3"]

[ ]

Item2

["A","B"]
["A","B","C"]
["A","B","A","B","C"]
["A","B"]

Item3

["D","E","F"]
["4","5","6"]
["D","E","F","4","5","6"]
[ ]

Column set 2:

Item

cross2

Item1

[["A","1"],["A","2"],["A","3"],["B","1"],["B","2"],["B","3"],["C","1"],["C","2"],["C","3"]]

Item2

[["A","A"],["A","B"],["A","C"],["B","A"],["B","B"],["B","C"]]

Item3

[["D","4"],["D","5"],["D","6"],["E","4"],["E","5"],["E","6"], ["F","4"],["F","5"],["F","6"]]

Column set 3:

Item

unique2

Item1

["A","B","C","1","2","3"]

Item2

["A","B","C"]

Item3

["D","E","F","4","5","6"]