topic Help with replacing already existing data in QlikView https://community.qlik.com/t5/QlikView/Help-with-replacing-already-existing-data/m-p/511835#M1137853 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>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</P><P></P><P>I have loaded in 2 spreadsheets</P><P></P><P>March 2013: Loads data from Jun 2012 - March 2013</P><P></P><P>Apr 2013: Loads data from June 2012 -April 2013</P><P></P><P></P><P></P><P>The Apr 2013 load has got 5 more records for April 2013 and 2 records deleted for March 2013.</P><P></P><P>I had hoped to add April 2013 onto the end (Which I have achieved) but also update/replace/delete any records from previous months</P><P>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</P><P></P><P>Can anyone kindly help me do this in the script?</P><P></P><P>Kind Regards</P><P>Helen</P></BODY></HTML> Wed, 23 Oct 2013 12:50:42 GMT helen_pip 2013-10-23T12:50:42Z Help with replacing already existing data https://community.qlik.com/t5/QlikView/Help-with-replacing-already-existing-data/m-p/511835#M1137853 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>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</P><P></P><P>I have loaded in 2 spreadsheets</P><P></P><P>March 2013: Loads data from Jun 2012 - March 2013</P><P></P><P>Apr 2013: Loads data from June 2012 -April 2013</P><P></P><P></P><P></P><P>The Apr 2013 load has got 5 more records for April 2013 and 2 records deleted for March 2013.</P><P></P><P>I had hoped to add April 2013 onto the end (Which I have achieved) but also update/replace/delete any records from previous months</P><P>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</P><P></P><P>Can anyone kindly help me do this in the script?</P><P></P><P>Kind Regards</P><P>Helen</P></BODY></HTML> Wed, 23 Oct 2013 12:50:42 GMT https://community.qlik.com/t5/QlikView/Help-with-replacing-already-existing-data/m-p/511835#M1137853 helen_pip 2013-10-23T12:50:42Z