Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Valued Contributor

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

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

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

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

LOok the atach

Community Browser