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.

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

Run the query

print zip(dynamic([1,3,5]), dynamic([2,4,6]))

Output

print_0
[[1,2],[3,4],[5,6]]

Run the query

print zip(dynamic(["A", 1, 1.5]), dynamic([{}, "B"]))

Output

print_0
[["A",{}], [1,"B"], [1.5, null]]

Run the query

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"]]