Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_brierley
Creator
Creator

Incremental load

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

1 Solution

Accepted Solutions
Anonymous
Not applicable

Samuel

Use:

     Store mytable into xyz.qvd (qvd);

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

Best Regards    Bill

View solution in original post

3 Replies
Anonymous
Not applicable

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
Creator
Creator
Author

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


Anonymous
Not applicable

Samuel

Use:

     Store mytable into xyz.qvd (qvd);

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

Best Regards    Bill