INCREMENTAL PROCESS

[chinnu123]

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.

[qlikviewwizard]

Hi,

Please check this thread.

Hope this will help you.

Incremental Load in Qlikview - Sources

[#3]

‌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

[sunny_talwar]

See if the attached qvws make sense to you.

Best,

Sunny

[sunny_talwar]

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