Scalar FunctionsDynamic / JSON Functions
pack_all
Create a property bag containing all column values.
Syntax
pack_all(ignore_null_empty)Parameters
Prop
Type
Returns: dynamic
Examples
Example 1 — Pack all columns into a property bag
datatable(warrior:string, weapon:string, voyages:long)[
"Ragnar", "axe", 42
]
| project bag = pack_all()| bag (dynamic) |
|---|
| {"voyages":42,"warrior":"Ragnar","weapon":"axe"} |
Example 2 — With ignore_null_empty — omits empty string fields
datatable(warrior:string, weapon:string, nickname:string)[
"Ragnar", "axe", ""
]
| project bag = pack_all(true)| bag (dynamic) |
|---|
| {"warrior":"Ragnar","weapon":"axe"} |