Recently I created a series of videos on Qlik User Interface (UI) design techniques and I was really pleased with the positive response I got from everyone here and on the Qlik Community.
Carrying on the same idea I’m putting together a series of videos focusing on loading data into QlikView and will include various techniques I’ve developed and seen others use other the years.
This video continues with the series and shows how the script is modified to create a recovery load, the next video in the series shows how the same script is then finalised into an incremental load.
I have really enjoyed your youTube channel so far, it has opened my mind to new possibilities. I am currently working on alternative data loads, validation of data, and recovery process improvements. Hopefully you can assist in my question below.
In your example you have one file extracting data into several QVD files. Do you have any insight into a recovery process that has multiple data files (20+ files) being extracted into several QVD files?
Hi Chris. Thanks for your nice words.
I often build in a recovery process. That is by changing the start and end dates on the reload.
In one company I worked for I created one qvw, that looked at several sources and extracted the data into multiple qvd files.
I used publisher to send a variable to the qvw to tell it what to do, is daily loads, weekly loads, recovery, etc.
The one file went to a control table which it looped through. Much in the same way as we loop though dates here. The file held data on what to connect to and where to put it. That way the same qvw can complete many takes. My loads then where simple * loads as they were views I’d set up in the database although I could have held a string of fields in a variable taken from the control sheet if I wished.
I hope this helps.