topic Re: Incremental load in QlikView

Incremental load

samuel_brierley — Fri, 18 Oct 2013 08:57:52 GMT

Hi there I know what im after is possible through incremental load but im unsure of how to go about it.

I am loading timesheet on a weekly basis into qlikview.

every week is a new file but obviously after a while reloading all the old timetable is going to become a lengthy process.

i want to be able to basically store the old files and only load the new script i will add every week allowing me to archive the old timesheets and greatly cutting down on reload time.

thanks for any help

Re: Incremental load

Anonymous — Fri, 18 Oct 2013 09:03:45 GMT

Samuel

Sounds like you are just adding additional rows, not updated or deleting them, so :

First run, store table into QVD
Next run, load QVD and concatenate new file onto it & store updated table to QVD

Best Regards Bill

Re: Incremental load

samuel_brierley — Fri, 18 Oct 2013 09:14:20 GMT

yes that's practically what im after, I hace concatenated all my tables but im unsure how to store?

Re: Incremental load

Anonymous — Fri, 18 Oct 2013 09:17:42 GMT

Samuel

Use:

Store mytable into xyz.qvd (qvd);

I have pasted that straight from QlikView Help, which gives you full information.

Best Regards Bill