Join tables

[Anonymous]

Hi!

I hace two tables with different number of columns but they share several columns.

Table A

Table B

Both tables have column "type".

I need to join both tables to include for each client the rows from table B of the same "type" that are not in table A.

This must be the result:

Any help?

Thanks a lot!

[lbendlin · Accepted solution]

Table A

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcjZU0lFyBGJfEMPQQClWB1nQCEnQCCZojE0QpjIWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [CUSTOMER = _t, TYPE = _t, MATERIAL = _t, NET = _t])
in
    Source

Table B

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUfI1VIrVgTKNEExjpdhYAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [TYPE = _t, MATERIAL = _t]),
    #"Added Custom" = Table.AddColumn(Source, "CUSTOMER", each List.Distinct(#"Table A"[CUSTOMER])),
    #"Expanded Customer" = Table.ExpandListColumn(#"Added Custom", "CUSTOMER")
in
    #"Expanded Customer"

Merge Table

let
    Source = #"Table A" & #"Table B",
    #"Removed Duplicates" = Table.Distinct(Source, {"CUSTOMER", "TYPE", "MATERIAL"})
in
    #"Removed Duplicates"