Skip to main content Skip to complementary content


Joins several arguments into one string, with a specific delimiter.

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.


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


Expression Result
concatWith(", ", "Smith", "John") "Smith, John"

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!