Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Tags (2)
2 Replies
nagaiank
Not applicable

Re: Where not exists - specific to table, not global

The following document may be of help:

The exists issue

Not applicable

Re: Where not exists - specific to table, not global

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?