I want to make a comparison between "Sales forecast present data" and "Sales forecast start-of-year data".
To do so, I got two tables, Table1 (start-of-year "snapshot" data) and Table2 ( present dynamic data):
and i want to merge those two tables to one like this:
I mean, I want to ignore from Table1.Customer values (historical) if there are present values in Table2.Customer and only append
Table1 rows that deleted over time (cancelled/aborted deals) to Table2.
Thanks in advance,