源码:let 源=Excel.CurrentWorkbook(){[Name="表2"]}[Content], Source= Table.UnpivotOtherColumns(源, {"客户名称"}, "attr", "val"), Trans =Table.RemoveColumns(Table.SplitColumn(Source , "attr",each[l=Text.Split(_,"_"),r=if l{0}"上年" then {"本年"}&l else l][r],{"年类","账龄区间"}),{"客户名称"}), Result= Table.Pivot(Trans, List.Distinct(Trans[年类]), "年类", "val", List.Sum)in Result
请教:
Trans = Table.RemoveColumns(Table.SplitColumn(Source , "attr",each [l=Text.Split(_,"_"),r=if l{0}"上年" then {"本年"}&l else l][r],{"年类","账龄区间"}),{"客户名称"}),
请问该句中each后的两个[],前一个我理解了,后一个[r]不知道是简写呢?对应table.splitColumn函数也不知道应该算是哪个参数?
谢谢! |