Something like this might work
//first off load all existing customer id's
CustTotNewToMove:
LOAD
Customerid as Customeridtomove
FROM
custtotnew.qvd (qvd)
;
//then work out which we have new records for
INNER JOIN (CustTotNewToMove)
LOAD
Customerid as Customeridtomove
FROM
[your new data file]
;
//then load existing custtotold records
CustTotOld:
LOAD
*
FROM custtotold.qvd (qvd)
;
//and append those from custtotnew where we have new records
CONCATENATE (CustTotOld)
LOAD
*
FROM custtotnew.qvd (qvd)
WHERE EXISTS (Customeridtomove, Customerid)
;
//and store, and drop
STORE CustTotOld;
DROP TABLE CustTotOld;
//then load new data
CustTotNew:
LOAD
*
FROM
[your new data file]
;
//and append custtotnew records where we don't have new data
CONCATENATE (CustTotNew)
LOAD
*
FROM custtotnew.qvd (qvd)
WHERE NOT Exists (Customerid);
