QVDs Refresh Only new Records

[#1]

Hi,

I've created a QVD with the script as below.

What I would like to do is a reload of the whole dataset on a Monday and then throughout the week, just do a hour load of the new updated records.

Q1. Do I need 2 separate QVDs so I can schedule the weekly and hourly refresh?

Q2. How do I refresh new records only and add them to the exisitng data?

Thank you in advance.

[senpradip007]

A1. Periodic QVDs can help you to fix any data mismatch.

A2. Incremental Load should be the solution of this problem.

[SreeniJD]

Hi Sharandeep,

Please refer following Incremental load in QV.

Incremental Load in Qlikview - Sources

QVDs will be always newly created having said that you can't data append into any existing QVD.

Sreeni

[#4]

Thank you

[#5]

What is periodic QVDs? How does this work?

[Anonymous]

Hi

Have a look about period QVD's:

https://community.qlik.com/message/859602#859602

Hope it helps!!

[Anonymous]

Hi,

Use Incremental Load, you can achieve your expected result.

Have a look:

Incremental Load in Qlikview - Sources

Hope it helps!!

[SreeniJD]

Hi Sharandeep,

Please mark the answer as hellpful or corect as relevant.

Sreeni

[senpradip007]

Have you got your desire solution? If yes close this thread by choosing correct or helpful answer for others to learn.