How to Update QVD with Latest Item Code?

[#1]

Hello,

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?

That's what a kind of sync issue. Please advise. Thank you.

[#2]

Hi,

It seems you are talking about a concept of "Slowly changing dimentions" is it?

please go through the below link:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions

[michael_anthony]

We manage these type of QVD's usually by doing a three step process:

LOAD records from source for anything that has changed, either new or updated.

CONCATENATE the table from the existing QVD for all records that weren't loaded above.  We use a WHERE NOT EXISTS test to handle this.

STORE the combined list back to QVD.