Concat

The Concat() function strings together a list of texts.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text that consists of the given values that are all concatenated. Returns Invalid expression if one of the parameter values is unknown or outside the common valid boundaries.

Syntax

Concat(values)

Concat("text1", "text2") => "text1text2"

Concat(values, delimiter)

Concat(List("text1", "textpart2", "listitem3"), "#SEP#") => "text1#SEP#textpart2#SEP#listitem3"

Concat(values, delimiter, last_delimiter)

Concat(List("text1", "textpart2", "listitem3"), "#SEP#", "$LAST$") => "text1#SEP#textpart2$LAST$listitem3"

Parameters

Name	Type	Required	Description
values	text or list	☑️	a list of text
delimiter	text		is placed between the parts when they are joined together.
last_delimiter	text		is placed between the last two parts.