pack_array()

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Packs all input values into a dynamic array.

Syntax

pack_array(value1, [ value2, ... ])

pack_array(*)

Name	Type	Required	Description
value1...valueN	`string`	✔️	Input expressions to be packed into a dynamic array.
The wildcard ``*	`string`		Providing the wildcard `*` packs all input columns into a dynamic array.

A dynamic array that includes the values of value1, value2, ... valueN.

range x from 1 to 3 step 1
| extend y = x * 2
| extend z = y * 2
| project pack_array(x, y, z)

Output

range x from 1 to 3 step 1
| extend y = tostring(x * 2)
| extend z = (x * 2) * 1s
| project pack_array(x, y, z)

Output