Merge NEW data from Table

[FranktheBank]

Hello,

I have two Power Query Tables, with one column that can link (have the same data in both tables) "Financial #" Table A has a "$ committed" column, "$ Spent" column and a "$ Remaining" Column. Table B has only a "$ Spent Column". I need to append or append new Table A adding on only what is not already on Table A. So the result would be like the following:

Table A

Financial #	Committed	Spent	Remaining
123	100	50	50
456	200	75	125
789	150	100	50

Table B

Financial #	Spent
123	50
456	75
789	100
890	200
901	25

Table C (or merge/Appended Table A)

Financial #	Committed	Spent	Remaining
123	100	50	50
456	200	75	125
789	150	100	50
890		200
901		25

There are plenty more columns and rows (3K+) and this will be updated monthly so it wouldn't be any easy Vlookup and delete.

Any and all help is appreciated. Thanks

 

[AlanSidman]

Load each table to PQ and then merge

let
Source = Table.NestedJoin(Table2, {"Financial #"}, Table1, {"Financial #"}, "Table1", JoinKind.LeftOuter),
#"Expanded Table1" = Table.ExpandTableColumn(Source, "Table1", {"Committed", "Remaining"}, {"Committed", "Remaining"}),
#"Reordered Columns" = Table.ReorderColumns(#"Expanded Table1",{"Financial #", "Committed", "Spent", "Remaining"})
in
#"Reordered Columns"