Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Packs all input values into a dynamic array.
Syntax
pack_array(value1, [ value2, ... ])
pack_array(*)
Learn more about syntax conventions.
Parameters
| 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. |
Returns
A dynamic array that includes the values of value1, value2, ... valueN.
Example
range x from 1 to 3 step 1
| extend y = x * 2
| extend z = y * 2
| project pack_array(x, y, z)
Output
| Column1 |
|---|
| [1,2,4] |
| [2,4,8] |
| [3,6,12] |
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
| Column1 |
|---|
| [1,"2","00:00:02"] |
| [2,"4","00:00:04"] |
| [3,"6","00:00:06"] |