Combining tables

[aviadbein]

Hi all,

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):

Table1:

Key	Customer
1	TBD
2	A2
3	TBD
4	A4

Table2:

Key	Customer
1	B1
3	B3
4	B4
5	B5
6	B6

and i want to merge those two tables to one like this:

Table:

Key	Customer
1	B1
2	A2
3	B3
4	B4
5	B5
6	B6

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.

P.S - I've already read help.qlik.com and this thread: Understanding Join, Keep and Concatenate

Thanks in advance,

Aviad

[Gysbert_Wassenaar]

Like this:

Table:

LOAD Key, Customer FROM Table2;

CONCATENATE (Table)

LOAD Key, Customer FROM Table1 WHERE Not Exists(Key);