Concatenate strings

Supported in: Batch, Streaming

Concatenates a list of strings with the specified separator.

Expression categories: String

Declared arguments

• Expressions - List of strings to be concatenated.
  List<Expression<String>>
• optional Separator - Separator to be added between the strings.
  Literal<String>

Output type: String

Examples

Example 1: Base case

Argument values:

• Expressions: [hello, world]
• Separator: _

Output: hello_world

---

Example 2: Null case

Argument values:

• Expressions: [hello, null, world, !]
• Separator: --

Output: hello--world--!

---