Aggregate FunctionsMake / Collect
make_set
Returns a dynamic (JSON) array of all distinct values of Expr in the group.
Syntax
make_set(expr)Parameters
Prop
Type
Returns: dynamic
Syntax
make_set(expr, max_size)Parameters
Prop
Type
Returns: dynamic
Syntax
make_set(expr, max_size)Parameters
Prop
Type
Returns: dynamic
Examples
Example 1
datatable(weapon:string, clan:string)[
"axe", "Lothbrok",
"sword", "Lothbrok",
"axe", "Lothbrok",
"spear", "Fairhair"
]
| summarize make_set(weapon) by clan| clan (string) | make_set_weapon (dynamic) |
|---|---|
| Fairhair | ["spear"] |
| Lothbrok | ["axe","sword"] |
Example 2
datatable(target:string, clan:string)[
"Lindisfarne", "Lothbrok",
"York", "Lothbrok",
"Paris", "Lothbrok"
]
| summarize make_set(target, 2) by clan| clan (string) | make_set_target (dynamic) |
|---|---|
| Lothbrok | ["Lindisfarne","York"] |