PQ-Auto filling information

[sandy666]

Table1Table2Result

NAMESAP NAMENAMESAP NAME

Andrew SmithAsmithBob DylanBdylan

Bob DylanBdylan

Chris PineCpine

Dave SpensorDspensor



// Join
let
Table1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Table2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
InnerJoin = Table.NestedJoin(Table1, {"NAME"}, Table2, {"NAME"}, "Table2", JoinKind.Inner),
TSC = Table.SelectColumns(InnerJoin,{"SAP NAME"})
in
TSC