Skip to main content Skip to complementary content


Joins several elements into one string.

Any data type can be used. Types other than string are converted to string before the function is applied.

Information noteNote: This function can be used both as an aggregation function or a string function, depending on the number of arguments.


At least two strings to concatenate, or an element containing an array or a group of elements to concatenate.


Expression Result
concat("Hello ", "World!") "Hello World!"
concat("Hello", null) "Hello"

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!