topic How to Update QVD with Latest Item Code? in QlikView https://community.qlik.com/t5/QlikView/How-to-Update-QVD-with-Latest-Item-Code/m-p/509161#M190259 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have QVD files for everyday records by item, however, after a period of time, the name of the item may be changed. In this case, how could I update old names in existing QVD files for that item while getting new records with new name into QVD?</P><P></P><P>That's what a kind of sync issue. Please advise. Thank you.</P></BODY></HTML> Wed, 21 Aug 2013 04:23:46 GMT 2013-08-21T04:23:46Z How to Update QVD with Latest Item Code? https://community.qlik.com/t5/QlikView/How-to-Update-QVD-with-Latest-Item-Code/m-p/509161#M190259 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have QVD files for everyday records by item, however, after a period of time, the name of the item may be changed. In this case, how could I update old names in existing QVD files for that item while getting new records with new name into QVD?</P><P></P><P>That's what a kind of sync issue. Please advise. Thank you.</P></BODY></HTML> Wed, 21 Aug 2013 04:23:46 GMT https://community.qlik.com/t5/QlikView/How-to-Update-QVD-with-Latest-Item-Code/m-p/509161#M190259 2013-08-21T04:23:46Z Re: How to Update QVD with Latest Item Code? https://community.qlik.com/t5/QlikView/How-to-Update-QVD-with-Latest-Item-Code/m-p/509162#M190260 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>It seems you are talking about a concept of "Slowly changing dimentions" is it?</P><P>please go through the below link:</P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions">http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions</A></P></BODY></HTML> Wed, 21 Aug 2013 04:44:42 GMT https://community.qlik.com/t5/QlikView/How-to-Update-QVD-with-Latest-Item-Code/m-p/509162#M190260 2013-08-21T04:44:42Z Re: How to Update QVD with Latest Item Code? https://community.qlik.com/t5/QlikView/How-to-Update-QVD-with-Latest-Item-Code/m-p/509163#M190261 <HTML><HEAD></HEAD><BODY><P>We manage these type of QVD's usually by doing a three step process:</P><P></P><P>LOAD records from source for anything that has changed, either new or updated.</P><P></P><P>CONCATENATE the table from the existing QVD for all records that weren't loaded above.&nbsp; We use a WHERE NOT EXISTS test to handle this.</P><P></P><P>STORE the combined list back to QVD.</P></BODY></HTML> Wed, 21 Aug 2013 04:47:29 GMT https://community.qlik.com/t5/QlikView/How-to-Update-QVD-with-Latest-Item-Code/m-p/509163#M190261 michael_anthony 2013-08-21T04:47:29Z