Where not exists - specific to table, not global

[#1]

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

[nagaiank]

The following document may be of help:

The exists issue

[#3]

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?