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

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
.

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

array_ref1, array_ref2

Array literal or name of the array column whose elements you want to concatenate together. You can conc atenate together two or more arrays.

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

Example - Simple concat example