QVDs Refresh Only new Records - Qlik Community

Report Inappropriate Content · ‎2015-10-01

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 · ‎2015-10-01

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

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

SreeniJD · ‎2015-10-01

Hi Sharandeep,

Please refer following Incremental load in QV.

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

Sreeni

Report Inappropriate Content · ‎2015-10-01

Thank you

Report Inappropriate Content · ‎2015-10-01

What is periodic QVDs? How does this work?

Anonymous · ‎2015-10-01

Hi

Have a look about period QVD's:

Hope it helps!!

Anonymous · ‎2015-10-01

Hi,

Use Incremental Load, you can achieve your expected result.

Have a look:

Hope it helps!!

SreeniJD · ‎2015-10-01

Hi Sharandeep,

Please mark the answer as hellpful or corect as relevant.

Sreeni

senpradip007 · ‎2015-10-01

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