2 Replies Latest reply: Nov 24, 2014 2:43 PM by Ritvik Menon RSS

    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