DuckDB function list_zip

Zips n LISTs to a new LIST whose length will be that of the longest list. Its elements are structs of n elements from each list list_1, …, list_n, missing elements are replaced with NULL. If truncate is set, all lists are truncated to the smallest list length.

Usage

list_zip()

Value

STRUCT[]

SQL examples

list_zip([1, 2], [3, 4], [5, 6])
list_zip([1, 2], [3, 4], [5, 6, 7])
list_zip([1, 2], [3, 4], [5, 6, 7], true)