ARRAY_TO_STRING

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Converts an array to a string using a separator and an optional null indicator.

• array: The array to convert.
• separator: The delimiter to insert between elements.

• null_string: The string to use for NULL elements.

Returns a text value that contains all array elements joined by the separator. Without the optional null_string parameter, NULL elements are omitted from the output.

Convert an array to a semicolon-separated string.

Returns '1;2;3', joining all elements with semicolons. The NULL element was ignored because no NULL value was specified.

Convert an array with NULL values using a custom null indicator.

Returns '3-2-1-N/A', replacing the NULL element with the specified indicator.

• Array Data Type