topic Where not exists - specific to table, not global in QlikView

Where not exists - specific to table, not global

Mon, 24 Nov 2014 19:10:24 GMT

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

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

nagaiank — Mon, 24 Nov 2014 19:17:55 GMT

The following document may be of help:

The exists issue

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

Mon, 24 Nov 2014 19:43:06 GMT

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?