Power Query list of lists to Table
Ngày đăng:
10/11/2021
Trả lời:
0
Lượt xem:
203
Welcome to our Power Query blog. This week, I look at the M function List.Zip and its uses. I have been looking at List functions in M language recently, and this one reminds me of my problems with null values in lists (please see Power Query: Sorry, Not on the List). The description of the function in the Microsoft help pages is straightforward: List.Zip(listsas list) as list Takes a list of lists,and returns a list of lists combining items at the same position. Since I have a simple example with two lists below, this will be my starting point. I also want to see if the function will cope with a null. |