Syntax

JoinArray ( dataArray [ , separator ] )

Arguments

dataArray An array of strings to be joined.

separator A string to be used as a separator. If omitted, the array elements are not separated with anything.

Returns

A string that is the result of concatenating the array elements.

Example

The following example finds the location of the word string in the string This is the string to search.

query: |
  SELECT JoinArray(@['Hello','World','!']) AS JoinArrayValue
template: |
  

[ { "JoinArrayValue": "HelloWorld!" } ]