Join
join
Concatenate string values within a group using a delimiter.
Spec
join(column, delimiter)Parameters
column - The string column to join.
delimiter - The string used as a separator between values. Defaults to "," when omitted.Return Value
A single string with all values joined by the delimiter.Example
Used inside summarize. Join strings per group:
datatable(group:string, val:string)["A", "foo", "A", "bar", "B", "baz"]
| summarize joined = join(val, ",") by group| group | joined |
|---|---|
| A | foo,bar |
| B | baz |
Collect unique pages per user:
pageviews
| where timestamp > ago(1h)
| summarize pages = join(page, " | ") by userId