KQL Search

Query Details

HomeAI ToolsDevice Query

Create And Query

Query

//Create a table, query the table

let MyTable = datatable (Category:string, Value:long) 
[ 
    "A", 1, 
    "A", 3, 
    "A", 5, 
    "B", 1, 
    "B", 2 
]; 
MyTable 
| extend PackedRecord = pack_all() 
| summarize Result = make_list(PackedRecord)

Explanation

This query creates a table with two columns (Category and Value) and then queries that table to summarize the data by packing all the records into a single column called PackedRecord and creating a list of those packed records in a column called Result.

Details

Rod Trent profile picture

Rod Trent

Released: February 22, 2024

Tables

MyTable

Keywords

Table,Query,Category,Value,PackedRecord,Result,MakeList,PackAll

Operators

extendpack_allsummarizemake_list

Actions