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.

Arrays are referenced by column name or as array literals.
This function applies two or more columns of Array type only. To concatenate string values, seeMerge Transform.
Duplicate values are not removed from the generated array.

Wrangle vs. SQL: This function is part of Wrangle, a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.

Basic Usage

Array literal reference example:

arrayconcat([["A","B","C"],["C","D","E"]])

Output: Generates the following array:

["A","B","C","C","D","E"]

Column reference example:

arrayconcat([array1,array2])

Output: Generates a new array containing a single array listing all of the elements in array1 followed by all elements from array2 in order.

Syntax and Arguments

arrayconcat(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

For more information on syntax standards, see Language Documentation Syntax Notes.

array_ref1, array_ref2

Array literal or name of the array column whose elements you want to concatenate together. Youcan concatenate together two or more arrays.

Usage Notes:

Required?	Data Type	Example Value
Yes	Array literal or column reference	`myArray1`, `myArray2`

Examples

Tip

For additional examples, see Common Tasks.

Example - Simple concat example

This simple example illustrates how the following functions operate on nested data.

ARRAYCONCAT - Concatenate multiple arrays together. See ARRAYCONCAT Function.
ARRAYINTERSECT - Find the intersection of elements between multiple arrays. See ARRAYINTERSECT Function.
ARRAYCROSS - Compute the cross product of multiple arrays. See ARRAYCROSS Function.
ARRAYUNIQUE - Generate unique values across multiple arrays. See ARRAYUNIQUE Function.

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`
Parameter: Formula type	Single row formula
Parameter: Formula	ARRAYCONCAT([Letters,Numerals])
Parameter: New column name	'concat2'

Transformation Name	`New formula`
Parameter: Formula type	Single row formula
Parameter: Formula	ARRAYINTERSECT([Letters,Numerals])
Parameter: New column name	'intersection2'

Transformation Name	`New formula`
Parameter: Formula type	Single row formula
Parameter: Formula	ARRAYCROSS([Letters,Numerals])
Parameter: New column name	'cross2'

Transformation Name	`New formula`
Parameter: Formula type	Single row formula
Parameter: Formula	ARRAYUNIQUE([Letters,Numerals])
Parameter: New column name	'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"]]

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"]

In this section: