- // Table2
let
Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
split = Table.TransformColumns(Source, {"订单号", each Text.Split(_, "/")}),
expd = Table.ExpandListColumn(split, "订单号"),
meg = Table.Join(expd, "订单号", Table1, "订单", JoinKind.LeftOuter),
cmbCols = Table.CombineColumns(meg, {"运费", "比例"}, List.Product, "运费"),
result = Table.SelectColumns(cmbCols, Table.ColumnNames(Source))
in
result
// Table1
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content]
in
Source
复制代码 供参考 |