Find and replace overlap in Tables

Question

Hi all,&nbsp;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?&nbsp;&nbsp;&nbsp;&nbsp;Thanks!&nbsp;

imkef · Accepted Answer

Hi&nbsp;Anonymous&nbsp;
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).&nbsp;
Then append that to TableB.
&nbsp;

Forum Discussion

Find and replace overlap in Tables

2 Replies

Related content

Replace text in table

2 visuals overlapping

Conditional Replace Using Outside table

replacing data without getting additional tables

Overlap table