|
最近在学Power Query
let
源 = Excel.CurrentWorkbook(){[Name="流水表!_FilterDatabase"]}[Content],
提升的标题 = Table.PromoteHeaders(源, [PromoteAllScalars=true]),
更改的类型 = Table.TransformColumnTypes(提升的标题,{{"序号", Int64.Type}, {"入库#(lf)出库", type text}, {"登记日期", type date}, {"出入库#(lf)单号", type text}, {"物品编码", type text}, {"物品名称", type text}, {"规格型号", type text}, {"计量单位", type text}, {"数量", Int64.Type}, {"单价", Int64.Type}, {"金额", Int64.Type}}),
合并的查询 = Table.NestedJoin(更改的类型,{"物品名称"},表2,{"列1"},"表2",JoinKind.LeftOuter),
#"展开的“表2”" = Table.ExpandTableColumn(合并的查询, "表2", {"列1"}, {"表2.列1"}),
筛选的行 = Table.SelectRows(#"展开的“表2”", each [表2.列1] <> null and [表2.列1] <> ""),
删除的其他列 = Table.SelectColumns(筛选的行,{"序号", "入库#(lf)出库", "登记日期", "出入库#(lf)单号", "数量"})
in
删除的其他列 |
|