Merges the elements of an array in left to right order into a string. Values are optionally delimited by a provided delimiter. |
Array literal reference example:
arraymergeelements(["A","B","C","D"],"-") |
Output: Returns the following String value: "A-B-C-D".
Column reference example:
arraymergeelements([myValues) |
Output: Generates the new myValuesMergedTogether column containing all of the elements in the arrays in the myElement column joined together without a delimiter between them.
arraymergeelements(array_ref,my_element, [string_delimiter]) |
| Argument | Required? | Data Type | Description |
|---|---|---|---|
| array_ref | Y | array | Name of Array column, Array literal, or function returning an Array to apply to the function |
| string_delimiter | Y | string | Optional String delimiter to insert between merged elements in the output String. |
Name of the array column, array literal, or function whose elements you wish to merge.
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | String (column reference or function) or array literal | myArray1 |
Optional string value to insert between elements in the merged output string.
| Required? | Data Type | Example Value |
|---|---|---|
| No | String | "-"
|