ETL: BagToString

Join all elements of a bag (array) into a single string with an optional delimiter character. Defaults to underscore if delimiter is omitted.

Description

Concatenates a bag into a string. If the delimiter argument is omitted, the character ’_’ is used.

Syntax

BagToString(bag_expression[, delimiter_string_expression])

Examples

BagToString(JsonStringToBag('[1,2,3]'),';') returns 1;2;3

Return value datatype

String

Impact of null value

If input is null, returns null.