Aggregate FunctionsMake / Collect
make_bag_if
Like `make_bag`, over the rows of the group for which `predicate` is true.
Values that are not property bags are skipped, and the result holds at most
max_size keys (default 1,048,576).
Syntax
make_bag_if(expr, predicate)Parameters
Prop
Type
Returns: dynamic
Syntax
make_bag_if(expr, predicate, max_size)Parameters
Prop
Type
Returns: dynamic
Syntax
make_bag_if(expr, predicate, max_size)Parameters
Prop
Type
Returns: dynamic
Examples
Example 1 — One bag from the kept rows
datatable(prop:string, value:string, keep:bool)[
"prop01", "val_a", true,
"prop02", "val_b", false,
"prop03", "val_c", true
]
| extend p = bag_pack(prop, value)
| summarize dict = make_bag_if(p, keep)| dict (dynamic) |
|---|
| {"prop01":"val_a","prop03":"val_c"} |