update and append when there is no uniq key

[userid128223]

Hi Everyone I have data that does not have 1:1 relation ship for update and append. In order to do find 1:1 relation ship between new_qvd & Master_QVD i have to create a composite key. However when i tried doing below it still does not give me the results I am looking for. It only takes all data in New_QVD and creates new Merge_Data.

Ideally what I want is update Master Data QVD with new updates (if it exist) in New_QVD and append new records that are not there.

Merge_Data:

LOAD

     ID,

     Date,

     StoreNo,

     Name,

     amount

FROM      NEW_QVD.qvd (qvd);    

Concatenate (Merge_Data)

LOAD

     ID,

     Date,

     StoreNo

     Name,

     amount

FROM      MASTER_QVD.qvd (qvd);    

WHERE not exists(ID&StoreNo&Date);

[userid128223]

Hi Swuehl

I haven't tried your solution because I know I will get key not found error.