CONCATALL

The CONCATALL function concatenates all items in a list using the specified delimiter.

Syntax

CONCATALL(["string1","string2",...,"stringn"],"delimiter")

Arguments

["string1", "string2", ..., "stringn"] - A list of items that need to be joined. A list of strings. Any number in the list will also be concatenated into a string.

delimiter - String delimiter, such as "--", " ", etc.

Examples

CONCATALL(["Product1","Product2"],"--")
//returns the concatenated string: Product1--Product2 

In the following example, we concatenated the values of a row dimension and a text input measure.

CONCATALL