Make Set
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"] |