|
大家好,以下是我的一个PQ函数。这个程序有两个输入,现在我想添加一个输入变量,替换程序中红色部分,请问我该怎么定义变量,又怎么替换红色内容为变量??关键问题就是这是一个记录的行头,我就懵了。
(od as table, fd as list) as any=>
let
//fd = {"BC","C-M"},
//od = PricingListWithGCWithTrue,
listnumber = List.Count(fd),
dr = List.Generate
(
()=>[i=1,s1 = Table.SelectRows(od, each Text.Contains([GROUP CODE], fd{0}))],
each <=listnumber,
each [i=+1, s1=Table.SelectRows(od, each Text.Contains([GROUP CODE],fd{i-1}))],
each [s1]
),
listtotable= Table.FromList(dr, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
ExpandTables = Table.ExpandTableColumn(listtotable, "Column1", {"CAT NO", "UNIT PRICE", "CUST.", "DATE", "PRICE TERM", "CURRENCY", "FC-LCL", "GROUP CODE"}, {"CAT NO", "UNIT PRICE", "CUST.", "DATE", "PRICE TERM", "CURRENCY", "FC-LCL", "GROUP CODE"}),
result = if listnumber > 0 then ExpandTables else od
in
result
|
|