make_set

Collects distinct values from a column into a dynamic (JSON) array.

Spec

make_set(arg0)

Parameters

arg0 - The column to collect distinct values from.

Return Value

A dynamic (JSON) array containing distinct non-null values.

Example

datatable(val:string)["a", "b", "a"]
| summarize unique_vals = make_set(val)

unique_vals
["a","b"]