List.zip

shufeabb

帮忙看看附件的list.zip有什么问题吗？改如何调整。

ThxAlot

1. let
   
2.     Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WerpnwZMdnUo6SqYGBgZAygJMGoJJXVMIZQKmwApidaKVns3tezp7NlDExBSmGEQZYdFjYgHV87yv+8muKSBToHqMYGZi6DEzhup5uqEf6jRjiB5TnPaYGSL0QN0G8YgZTu+YmCFZA3aaGUTeHKcWMxMkW/YsAIlAzLfErcUcoQUYBhDjkQIAm2fMTRF6gGGNiBtDY5x6TMG+iQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [姓名 = _t, 基本工资 = _t, 奖金 = _t, 学历津贴 = _t, 保险 = _t, 住房公积金 = _t, 实发工资 = _t]),
   
3. 
   
4.     #"Inserted Rows" = let tl = Table.ColumnNames(Source), new = Record.FromList(tl, tl) in List.Accumulate({1..Table.RowCount(Source)}, Source, (s,c) => Table.InsertRows(s, 2*c-1, {new}))
   
5. in
   
6.     #"Inserted Rows"

复制代码

shufeabb

能帮忙看看用List.zip如何修改可以实现吗？

zjnfxxh

这大括号也能乱加