Aggregate FunctionsMake / Collect
make_bag
Returns a dynamic property bag holding every key of the property-bag values of `expr` in the group.
Values that are not property bags are skipped. When a key appears in more than one bag, one of its values is kept; which one is unspecified, as in Kusto. Keys are returned sorted.
The result holds at most max_size keys (default 1,048,576).
Syntax
make_bag(expr)Parameters
Prop
Type
Returns: dynamic
Syntax
make_bag(expr, max_size)Parameters
Prop
Type
Returns: dynamic
Syntax
make_bag(expr, max_size)Parameters
Prop
Type
Returns: dynamic
Examples
Example 1 — One bag from one key per row
datatable(prop:string, value:string)[
"prop01", "val_a",
"prop02", "val_b",
"prop03", "val_c"
]
| extend p = bag_pack(prop, value)
| summarize dict = make_bag(p)| dict (dynamic) |
|---|
| {"prop01":"val_a","prop02":"val_b","prop03":"val_c"} |