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.
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.