Aggregate FunctionsMake / Collect
make_list
Returns a dynamic (JSON) array of all values of Expr in the group.
Syntax
make_list(expr)Parameters
Prop
Type
Returns: dynamic
Syntax
make_list(expr, max_size)Parameters
Prop
Type
Returns: dynamic
Syntax
make_list(expr, max_size)Parameters
Prop
Type
Returns: dynamic
Examples
Example 1
datatable(warrior:string, region:string)[
"Ragnar", "Kattegat",
"Bjorn", "Uppsala",
"Ivar", "Kattegat",
"Harald", "Vestfold"
]
| summarize make_list(warrior) by region| region (string) | make_list_warrior (dynamic) |
|---|---|
| Kattegat | ["Ragnar","Ivar"] |
| Uppsala | ["Bjorn"] |
| Vestfold | ["Harald"] |
Example 2
datatable(warrior:string, region:string)[
"Ragnar", "Kattegat",
"Bjorn", "Uppsala",
"Ivar", "Kattegat"
]
| summarize make_list(warrior, 2) by region| region (string) | make_list_warrior (dynamic) |
|---|---|
| Kattegat | ["Ragnar","Ivar"] |
| Uppsala | ["Bjorn"] |