Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude Data bases on a 2nd sheet during load process

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

3 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

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;


talk is cheap, supply exceeds demand
nicolett_yuri

LOok the atach