group_concat

utility

Concatenates values with optional separator

Syntax

group_concat(array, separator?)

array (array)

The array of values to concatenate

separator (string) optional

Separator string (default is empty string)

string

Concatenated string with values joined by separator

Join names with comma separator

Input:

map(.name) | group_concat(", ")

Output:

"Alice, Bob, Charlie"

Join numbers with dash separator

Input:

[1, 2, 3] | group_concat("-")

Output:

"1-2-3"

The group_concat() function concatenates array values into a single string with an optional separator.

Use group_concat() to combine multiple values into a single field, create comma-separated lists, or aggregate text data.