Store frequently changing data locally

[ahmed_hassan]

Dear Community

I am loading data from an SQL server and save it locally into QVD. The problem is that the SQL server deletes/edit the old data from time to time. Therefore, I have to save it locally and edit the saved QVD based on the changes which happens.

Note: It would be easy if the data doesn't get edited, as I could save it weekly intro multiple QVDs. However, it is hard to trace the changes which happens to the old data.

Is there anyway to solve this issue??

Thanks in advace.

[rubenmarin · Accepted solution]

Hi, there is an example in the help page about how to store qvds, it needs modificationTime, have you checked that sample?

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/QVD_Incremental.htm#Inse...

[Vegar]

You should look into the topic incremental load.

There are several writings and blog posts about the topic available online, this blog post could be a good place to start: https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

[ahmed_hassan]

Thanks for the support !