Find and replace overlap in Tables

[Anonymous]

Hi all,

I want to create a combined table. I have table A and table B. The endresult should be that whenever there is a corresponing row present in situation B it should overwrite or add to situation A resulting in table C. Any ideas how to achieve this result?

Thanks!

[ImkeF · Accepted solution]

Hi @Anonymous 

First you merge TableA with TableB on JoinKind.LeftAnti: This returns all rows that are present in TableA, but not in Table B (green part). 

Then append that to TableB.

[Anonymous]

Well this looks brilliant. Thanks!