编辑

通过

你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。

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

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