topic Re: incremental load in QlikView

incremental load

prabhas277 — Fri, 22 Jan 2016 05:35:34 GMT

Hi Experts,

In the incremental load first we can load data from the database then we can create the QVD again we have to load all new data by using filter conditions and create the QVD. here the QVD which i was created by earlier is overwrite by this new QVD,Now there is no old QVD

so i want that old QVD how can i get it?

Thanks in Advance

Re: incremental load

jonathandienst — Fri, 22 Jan 2016 05:39:09 GMT

If you don't have a backup, you cannot "get it". But if the database content used for the original qvd is unchanged, then you could easily recreate it by using the same filter conditions. Then make a back up.

Re: incremental load

Anonymous — Fri, 22 Jan 2016 05:43:01 GMT

Their is no alternate to recover your old QVD if you have overirde with new data.

You have to go to database and create same qvd again without condition

See this as well:

Incremental Load in QlikView – Part1 | Learn QlikView

Incremental Load in QlikView – Part2 | Learn QlikView

Re: incremental load

Mahamed_Qlik — Fri, 22 Jan 2016 06:57:16 GMT

Hi Prabhavs,

As it is not possible to recover your old qvd using Qlik.

Only suggestion is to use any data recovery software so that you can get your old QVD as well.

Hope this helps you out.

Regards,

Mahamed

Re: incremental load

manojkulkarni — Fri, 22 Jan 2016 06:58:41 GMT

Refer below links to under incremental load in detail

Incremental Load Script

Script for Incremental Loading of Multiple QVDs from a List of Table Names

https://www.resultdata.com/three-types-of-qlikview-incremental-loads/

Re: incremental load

Fri, 22 Jan 2016 08:23:30 GMT

Hi,

Its not possible to retrieve the old qvd..but as the new QVD created contains the old QVD data, we can make a copy of new QVD and delete the last reload data based on some date field. This only works if there are inserts. This fails if there are any Updates and Delets in the latest run.

Re: incremental load

jayaramp — Fri, 22 Jan 2016 08:40:10 GMT

Hi,

If the place you work has decent data backup practices, you should be able to retrieve the QVD from the backup.

Right click on the folder that contained the QVD and go to properties option and follow the image below.

Hope this helps...

Re: incremental load

dinuwanbr — Fri, 22 Jan 2016 08:59:33 GMT

Hi,

have to say sorry u can't retrieve your old data file. You have to re run the without conditions to get that. For incremental reload save your second qvd file (when query with filters) with a different name.

Rgds,

Dinu1

Re: incremental load

effinty2112 — Fri, 22 Jan 2016 09:08:58 GMT

Hi Prabhas,

Sorry you've lost your old qvd but if it has been overwritten QV cannot recover it. After all, if you overwrite an xls file you wouldn't expect Excel to be able to retrieve the old one one would you?