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

Where not exists - specific to table, not global

Lets say I have 2 tables, the key they share is called ID

table1 has info for ID 1 , 2, 3

table2 has info for ID 3,4,5

Now i want to do a partial reload for table2 and my new csv has info for ID 1,2,3,4,5

so i want to do

ADD ONLY LOAD * FROM

newData.csv

where not Exists (ID);

however the where not exists checks if the ID exists across ALL TABLES. I want to check if it exists only in Table2. Is this possible with partial reload? How would i do that

2 Replies
nagaiank
Specialist III
Specialist III

The following document may be of help:

The exists issue

Not applicable
Author

thanks for the reply!

so that suggests creating a duplicate column on Key with a different name and then do the where not exists on that.

That would be a very large increase in my memory footprint though. Is there no other way?