Exclude Data bases on a 2nd sheet during load process

[#1]

Hi all

I have a short question and maybe you can help me.

In the first table there are all customers with all details inside and in the second Table there are customers I have to exclude during the load process of table 1.

connection between both tables is Customer ID

Table 1

Customer 1

Customer 2

Customer 3

Customer 4

Table 2

Customer 4

Data that should be in QlikView File visible: Customer 1, 2 and 3

Hope you can help, cheers

oliver

[bbi_mba_76]

Hi,

I think you could use an inner join with the second table using the not exists function.

[Gysbert_Wassenaar]

Load Table2 first and then load Table1

Temp:

Load Customer from table2source;

Result:

Load Customer, x,y,z, ...etc from table1source

where not exists(Customer);

Drop table Temp;

[nicolett_yuri]

LOok the atach