Excel combination of tables

Hello, I'm trying to figure out the best way to get a table with information from two seperate tables. In the first table I got article numbers in column A. Each article consists of multiple comp...

excel

SergeiBaklan

Nov 11, 2024

You may use Power Query to merge tables

let
    Source = Table.NestedJoin(
        Table1, {"Onderdeel Code"},
        Table2, {"Deeg"}, "Table2",
        JoinKind.LeftOuter),
    ExpandTable2 = Table.ExpandTableColumn(
        Source,
        "Table2",
        {"Code"}, {"Code.1"}),
    AddComponent = Table.AddColumn(
        ExpandTable2,
        "Component",
        each
            if [Code.1] = null
            then [Onderdeel Code] else
            [Code.1]
    ),
    SelectColumns = Table.SelectColumns(
        AddComponent,
        {"Code", "Component"})
in
    SelectColumns

Please check attached.

Excel combination of tables.xlsx19 KB

let Source = Table.NestedJoin( Table1, {"Onderdeel Code"}, Table2, {"Deeg"}, "Table2", JoinKind.LeftOuter), ExpandTable2 = Table.ExpandTableColumn( Source, "Table2", {"Code"}, {"Code.1"}), AddComponent = Table.AddColumn( ExpandTable2, "Component", each if [Code.1] = null then [Onderdeel Code] else [Code.1] ), SelectColumns = Table.SelectColumns( AddComponent, {"Code", "Component"}) in SelectColumns

Forum Discussion

Excel combination of tables

Resources