topic Re: Store frequently changing data locally in QlikView

Store frequently changing data locally

ahmed_hassan — Tue, 23 Oct 2018 07:49:49 GMT

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.

Re: Store frequently changing data locally

rubenmarin — Tue, 23 Oct 2018 16:48:33 GMT

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#Insert__Update_and_Delet…

Re: Store frequently changing data locally

Vegar — Tue, 23 Oct 2018 17:28:52 GMT

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/

Re: Store frequently changing data locally

ahmed_hassan — Fri, 26 Oct 2018 06:42:18 GMT

Thanks for the support !