Discussion Board for collaboration on QlikView Scripting.
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
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
The following document may be of help:
The exists issue
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?