Incremental load

[samuel_brierley]

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

[Anonymous]

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

[samuel_brierley]

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

[Anonymous · Accepted solution]

Samuel

Use:

     Store mytable into xyz.qvd (qvd);

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

Best Regards    Bill