topic Re: Exclude Data bases on a 2nd sheet during load process in QlikView

Exclude Data bases on a 2nd sheet during load process

Thu, 07 Nov 2013 09:44:58 GMT

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

Re: Exclude Data bases on a 2nd sheet during load process

bbi_mba_76 — Thu, 07 Nov 2013 09:52:07 GMT

Hi,

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

Re: Exclude Data bases on a 2nd sheet during load process

Gysbert_Wassenaar — Thu, 07 Nov 2013 10:02:35 GMT

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;

Re: Exclude Data bases on a 2nd sheet during load process

nicolett_yuri — Thu, 07 Nov 2013 19:45:05 GMT

LOok the atach