bag_pack ()

  • 發行項

從索引鍵和值清單中建立 動態 屬性包物件。

已被取代的別名:p ack () 、pack_dictionary ()

語法

bag_pack(key1,value1,key2,value2,... )

深入瞭解 語法慣例。

參數

名稱 類型 必要 描述
key string ✔️ 索引鍵名稱。
value string ✔️ 索引鍵值。

注意

索引鍵和值字串是替代清單，清單的總長度必須是偶數。

傳回

dynamic從列出的索引鍵和值輸入傳回屬性包物件。

範例

範例 1

下列範例會從替代的索引鍵和值清單中建立並傳回屬性包。

執行查詢

print bag_pack("Level", "Information", "ProcessID", 1234, "Data", bag_pack("url", "www.bing.com"))

結果

print_0
{“Level”：“Information”，“ProcessID”：1234，“Data”：{“url”：“www.bing.com”}}

範例 2

下列範例使用兩個數據表 SmsMessages 和 MmsMessages，並從其他數據行傳回其通用數據行和屬性包。 數據表會在查詢過程中建立臨機操作。

SmsMessages

SourceNumber TargetNumber CharsCount
555-555-1234 555-555-1212 46
555-555-1234 555-555-1213 50
555-555-1212 555-555-1234 32

MmsMessages

SourceNumber TargetNumber AttachmentSize AttachmentType AttachmentName
555-555-1212 555-555-1213 200 jpeg Pic1
555-555-1234 555-555-1212 250 jpeg Pic2
555-555-1234 555-555-1213 300 png Pic3

執行查詢

let SmsMessages = datatable (
    SourceNumber: string,
    TargetNumber: string,
    CharsCount: string
) [
    "555-555-1234", "555-555-1212", "46", 
    "555-555-1234", "555-555-1213", "50",
    "555-555-1212", "555-555-1234", "32" 
];
let MmsMessages = datatable (
    SourceNumber: string,
    TargetNumber: string,
    AttachmentSize: string,
    AttachmentType: string,
    AttachmentName: string
) [
    "555-555-1212", "555-555-1213", "200", "jpeg", "Pic1",
    "555-555-1234", "555-555-1212", "250", "jpeg", "Pic2",
    "555-555-1234", "555-555-1213", "300", "png", "Pic3"
];
SmsMessages 
| join kind=inner MmsMessages on SourceNumber
| extend Packed=bag_pack("CharsCount", CharsCount, "AttachmentSize", AttachmentSize, "AttachmentType", AttachmentType, "AttachmentName", AttachmentName) 
| where SourceNumber == "555-555-1234"
| project SourceNumber, TargetNumber, Packed

結果

SourceNumber TargetNumber Packed
555-555-1234 555-555-1213 {“CharsCount”：“50”，“AttachmentSize”：“250”，“AttachmentType”：“jpeg”，“AttachmentName”：“Pic2”}
555-555-1234 555-555-1212 {“CharsCount”：“46”，“AttachmentSize”：“250”，“AttachmentType”：“jpeg”，“AttachmentName”：“Pic2”}
555-555-1234 555-555-1213 {“CharsCount”：“50”，“AttachmentSize”：“300”，“AttachmentType”：“png”，“AttachmentName”：“Pic3”}
555-555-1234 555-555-1212 {“CharsCount”：“46”，“AttachmentSize”：“300”，“AttachmentType”：“png”，“AttachmentName”：“Pic3”}