zip()
Applies to: ✅ Microsoft Fabric ✅ 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.
zip(
arrays)
Learn more about syntax conventions.
Name | Type | Required | Description |
---|---|---|---|
arrays | dynamic |
✔️ | The dynamic array values to zip. The function accepts between 2-16 arrays. |
Kusto
print zip(dynamic([1,3,5]), dynamic([2,4,6]))
Output
print_0 |
---|
[[1,2],[3,4],[5,6]] |
Kusto
print zip(dynamic(["A", 1, 1.5]), dynamic([{}, "B"]))
Output
print_0 |
---|
[["A",{}], [1,"B"], [1.5, null]] |
Kusto
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"]] |