topic Re: Store in QVD with Incremenatal Load in QlikView

Store in QVD with Incremenatal Load

Sat, 26 Mar 2016 10:05:29 GMT

Hi Experts,

I have a requirement like, have to store data in QVD's by monthly with incremental load. How to achieve this?

Thanks,

swuehl — Sat, 26 Mar 2016 10:31:30 GMT

Download the delta load (incremental load) template from Rob Wunderlich's QV cookbook site:

It does a very good job in explaining the principles of an incremental load (see the script section of the QVW).

Hope this helps,

Stefan

avinashelite — Mon, 28 Mar 2016 05:51:50 GMT

check this links for more information

Anonymous — Mon, 28 Mar 2016 05:58:36 GMT

Check this link

Chanty4u — Mon, 28 Mar 2016 09:20:07 GMT

chk dis

jagan — Thu, 07 Apr 2016 11:15:46 GMT

Hi,

Check this

Data:

LOAD

FROM DataSource

WHERE MonthName(DateFieldName) = MonthName(Today());

LET vCurrentMonth = MonthName(Today());

STORE Data INTO [$(vCurrentMonth).qvd];

Like this create qvd for every month.

Regards,

Jagan.