Forum Discussion
Find and replace overlap in Tables
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 situa...
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.
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.
Well this looks brilliant. Thanks!