pack_all()

Learn how to use the pack_all() function to create a dynamic object from all the columns of the tabular expression.

Creates a dynamic property bag object from all the columns of the tabular expression.

Syntax

pack_all([ ignore_null_empty ])

Parameters

NameTypeRequiredDescription
ignore_null_emptyboolIndicates whether to ignore null/empty columns and exclude them from the resulting property bag. The default value is false.

Example

The following query will use pack_all() to create columns for the below table.

SourceNumberTargetNumberCharsCount
555-555-1234555-555-121246
555-555-1234555-555-121350
555-555-131342
555-555-345674
datatable(SourceNumber:string,TargetNumber:string,CharsCount:long)
[
'555-555-1234','555-555-1212',46,
'555-555-1234','555-555-1213',50,
'555-555-1313','',42, 
'','555-555-3456',74 
]
| extend Packed=pack_all(), PackedIgnoreNullEmpty=pack_all(true)

Output

SourceNumberTargetNumberCharsCountPackedPackedIgnoreNullEmpty
555-555-1234555-555-121246{“SourceNumber”:“555-555-1234”, “TargetNumber”:“555-555-1212”, “CharsCount”: 46}{“SourceNumber”:“555-555-1234”, “TargetNumber”:“555-555-1212”, “CharsCount”: 46}
555-555-1234555-555-121350{“SourceNumber”:“555-555-1234”, “TargetNumber”:“555-555-1213”, “CharsCount”: 50}{“SourceNumber”:“555-555-1234”, “TargetNumber”:“555-555-1213”, “CharsCount”: 50}
555-555-131342{“SourceNumber”:“555-555-1313”, “TargetNumber”:"", “CharsCount”: 42}{“SourceNumber”:“555-555-1313”, “CharsCount”: 42}
555-555-345674{“SourceNumber”:"", “TargetNumber”:“555-555-3456”, “CharsCount”: 74}{“TargetNumber”:“555-555-3456”, “CharsCount”: 74}