zip()
Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
The zip function accepts any number of dynamic arrays, and returns an
array whose elements are each an array holding the elements of the input
arrays of the same index.
Syntax
zip(arrays)
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| arrays | dynamic |
✔️ | The dynamic array values to zip. The function accepts between 2-16 arrays. |
Examples
print zip(dynamic([1,3,5]), dynamic([2,4,6]))
Output
| print_0 |
|---|
[[1,2],[3,4],[5,6]] |
print zip(dynamic(["A", 1, 1.5]), dynamic([{}, "B"]))
Output
| print_0 |
|---|
[["A",{}], [1,"B"], [1.5, null]] |
datatable(a:int, b:string) [1,"one",2,"two",3,"three"]
| summarize a = make_list(a), b = make_list(b)
| project zip(a, b)
Output
| print_0 |
|---|
[[1,"one"],[2,"two"],[3,"three"]] |