topic Re: QVDs Refresh Only new Records in QlikView

QVDs Refresh Only new Records

Thu, 01 Oct 2015 07:07:10 GMT

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 — Thu, 01 Oct 2015 07:13:23 GMT

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

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

SreeniJD — Thu, 01 Oct 2015 07:14:04 GMT

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

Thu, 01 Oct 2015 08:10:53 GMT

Thank you

Thu, 01 Oct 2015 08:11:43 GMT

What is periodic QVDs? How does this work?

Anonymous — Thu, 01 Oct 2015 08:26:13 GMT

Have a look about period QVD's:

Hope it helps!!

Anonymous — Thu, 01 Oct 2015 08:28:07 GMT

Hi,

Use Incremental Load, you can achieve your expected result.

Have a look:

Hope it helps!!

SreeniJD — Thu, 01 Oct 2015 08:41:13 GMT

Hi Sharandeep,

Please mark the answer as hellpful or corect as relevant.

Sreeni

senpradip007 — Thu, 01 Oct 2015 11:09:28 GMT

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