CONCAT

The CONCAT Function

Function Group: Collection

CONCAT concatenates one or more arrays and returns the result an array.

Syntax

CONCAT([args...])

• args is one or more arrays
• CONCAT can take an arbitrary number arguments

Uses

Let's say we're given a response with some vehicle information that looks like this:

{  
   "data":{  
      "japanese_brands":[ "Toyota", "Honda", "Nissan" ],
      "german_brands":[ "Volvo", "BMW", "Mercedes Benz" ]
   }
}

Let's say we want to combine the two brand arrays into one array containing all brand names. We can do it using CONCAT:

CONCAT(data.japanese_brands, data.german_brands)

This would return [ "Toyota", "Honda", "Nissan", "Volvo", "BMW", "Mercedes Benz" ].