join
To return a string consisting of all items of the given string array separated by a given separator.
Merge multiple elements from an array or table into one string.
Unlike the function concat(), however, you can specify here which character should separate the elements. This can be a comma, for example, but also a line break. If you select a line break, you can output the entries in a multiline text field.
The function has nothing in common with the SQL statement of the same name.
Syntax
join([string], string)
Return
string
Examples
join(stringArray, separator) To return a string consisting of all items of the given string array separated by a given separator. The separator can be a line break.
join(["A", "B", "C"], "
")Result: A B C
join((select Customer where Sales > 10000).Name, ", ")Result: The names of all customers whose sales are higher than €10,000, one after the other, separated by commas.
See also
concat, which returns all items of an array in one string.