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
Concatenates many dynamic arrays to a single array.
Syntax
array_concat(arr [, ...])
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| arr | dynamic |
✔️ | The arrays to concatenate into a dynamic array. |
Returns
Returns a dynamic array of all input arrays.
Examples
The following example shows concatenated arrays.
range x from 1 to 3 step 1
| extend y = x * 2
| extend z = y * 2
| extend a1 = pack_array(x,y,z), a2 = pack_array(x, y)
| project array_concat(a1, a2)
Output
| Column1 |
|---|
| [1,2,4,1,2] |
| [2,4,8,2,4] |
| [3,6,12,3,6] |