topic Re: INCREMENTAL PROCESS in QlikView

INCREMENTAL PROCESS

chinnu123 — Thu, 17 Sep 2015 21:21:19 GMT

Hi Community,

Can any one suggest me incremental process for below scenario...

My scenario is every time i will be having 2 months of data in excel i.e; (previous and existing month)

so the incremental process should go on in the same format.

For Eg: in the attached sample excel, i have June and July for the existing month-July.

Next time it will be July and August for the existing month-August.

August and September for the existing month-September, and the process goes on.

Also the data gets overridden every month in the SharePoint but not appended.

Re: INCREMENTAL PROCESS

qlikviewwizard — Fri, 18 Sep 2015 01:45:53 GMT

Hi,

Please check this thread.

Hope this will help you.

Incremental Load in Qlikview - Sources

Re: INCREMENTAL PROCESS

Fri, 18 Sep 2015 01:49:52 GMT

‌I would suggest something along the lines of

read the data initally and store in qvd

next time the app runs, open the qvd which haa the previous data, load the excel and concatenation to the loaded qvd data

store the qvd

next time the app runs, repeat the process

ypu basically want to open the past data, append current data and store

Re: INCREMENTAL PROCESS

sunny_talwar — Fri, 18 Sep 2015 03:08:53 GMT

See if the attached qvws make sense to you.

Best,

Sunny

Re: INCREMENTAL PROCESS

sunny_talwar — Fri, 18 Sep 2015 03:27:38 GMT

I don't have the time to go over step by step instructions right now. But when I have time, I can go over the details if you are still not able to figure it out.

Best,

Sunny