用PQ 实现VLOOKUP修改表 怎么做

hbzql

let
    源 = Excel.CurrentWorkbook(),
    订单表 = Table.PromoteHeaders(源{[Name="订单表"]}[Content]),
    套装表 = Table.PromoteHeaders(源{[Name="套装表"]}[Content]),
    合并查询 = Table.NestedJoin(订单表,"SKU", 套装表,"套装SKU","查询",0),
    展开查询结果 = Table.ReorderColumns(Table.ExpandTableColumn(Table.SelectColumns(合并查询,{"订单号","用户Id","件数","查询"}),"查询",List.RemoveItems(Table.ColumnNames(套装表),{"套装SKU"})), Table.ColumnNames(订单表)),
    去除查询 = Table.RemoveColumns(Table.NestedJoin(订单表,"SKU", 套装表,"套装SKU","查询",4),"查询"),
    自定义1 = 展开查询结果 & 去除查询
in
    自定义1