You could potentially use Partial Reload for question 2.
If you run an if statement and use the IsPartialReload() function to check if you're doing a partial reload, you can then do an ADD LOAD to just add new data to the existing table, and then maybe run a full reload on a weekly basis or something.
However, if it takes 2 hours to run the reload, I would suggest using incremental reload, store the tables into QVD files, and then use these for your user documents, and they should load quickly. The actual QVD generator document you can schedule to run nightly for example.
Thank you all for your answers. I have found them useful, but my main goal is to achieve this.
I have 12 months of info loaded into my QlikView app which takes 6 hours for a full reload and this will continue to increase over time. With the use of incremental load, I want to be able to only add information for every current month to the application directly. I am fine with concatenating and getting a qvd that will have both the recent and historic data. That is not my problem. My problem is being able to load only one month of info for the current month directly to my qvw file, so that I don't need to do a full reload always?
I hope I have provided enough information.
Any help would be greatly appreciated.