bag_pack_columns()

Learn how to use the bag_pack_columns() function to create a dynamic JSON object from a list of columns.

Creates a dynamic property bag object from a list of columns.

Syntax

bag_pack_columns(column1, column2,... )

Parameters

NameTypeRequiredDescription
columnscalar✔️A column to pack. The name of the column is the property name in the property bag.

Returns

Returns a dynamic property bag object from the listed columns.

Examples

The following example creates a property bag that includes the Id and Value columns:

datatable(Id: string, Value: string, Other: long)
[
    "A", "val_a", 1,
    "B", "val_b", 2,
    "C", "val_c", 3
]
| extend Packed = bag_pack_columns(Id, Value)
IdValueOtherPacked
Aval_a1{
“Id”: “A”,
“Value”: “val_a”
}
Bval_b2{
“Id”: “B”,
“Value”: “val_b”
}
Cval_c3{
“Id”: “C”,
“Value”: “val_c”
}

|C|val_c|3|{
“Id”: “C”,
“Value”: “val_c”
}|