Date: Thu, 27 Jan 2022 23:52:44 +0000 (GMT) Message-ID: <1196829103.127148.1643327564590@9c5033e110b2> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_127147_1607665606.1643327564589" ------=_Part_127147_1607665606.1643327564589 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html EXAMPLE - Nested Functions

EXAMPLE - Nested Functions

This simple example illustrates how the following functions oper= ate on nested data.

Source:

Code formatting has been applied to improve legibility.

=20 =20 =20 =20
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 res= erved word.

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula ARRAYCONCAT([Letters,Numerals])=20 'concat2'
=20

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula ARRAYINTERSECT([Letters,Numerals])<= /td>=20 'intersection2'
=20

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula ARRAYCROSS([Letters,Numerals]) 'cross2'
=20

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula ARRAYUNIQUE([Letters,Numerals])=20 'unique2'
=20

Results:

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

Column set 1:

=20 =20 =20 =20 =20 =20
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"]
------=_Part_127147_1607665606.1643327564589--