Hello
I have attached a QVD for reference, but what I am trying to achieve is to replace already existing records which already exist form the Temp table with the updated records from the SECOND_LOAD table
I have loaded in 2 spreadsheets
March 2013: Loads data from Jun 2012 - March 2013
Apr 2013: Loads data from June 2012 -April 2013
The Apr 2013 load has got 5 more records for April 2013 and 2 records deleted for March 2013.
I had hoped to add April 2013 onto the end (Which I have achieved) but also update/replace/delete any records from previous months
In this instance by loading in the SECOND_LOAD statement, 2 records from March should be deleted, and there should only be 5 records for March 2013
Can anyone kindly help me do this in the script?
Kind Regards
Helen
