Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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
bill_markham

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
bill_markham

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?


bill_markham

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