Restoration

parpatra — Thu, 04 Nov 2010 21:36:17 GMT

I need sugesstions for the following:

There are 3 flat files in a location from which I have to load my QVD.The files are monthly files and should be landed in the required location by 5th of each month. The re-load is scheduled for 6th. What if one of the files is not updated? For now I have built a script which will pick up the 'delta data' from the file and load it into the QVD. Now if a particular file is not updated it will run the reload process and load data for the other 2 file and do not do anything for the 'unchanged file'. Then I have alerts set up which will check if the data from a QVD is from the previous month then send an alert. But can this be handled before reloading? I mean can I send the alert from the script level where it finds that the max QVD date is equal to max of file date.
Let say we have a field A which is used in one of my charts. Then after a 5 months our Data base guys changed logic to store that information in another field B. So there is a chance that we have already loaded that into Qlikview for 6 months. Now how do I go back to a previous month and reload again? I can think of deleting the QVD and then restarting from 1st month...then pausing after5th month and then changing code for the 6th month and continue reloading. But is there a better option for this? Something like a restoration point in Qlikview?

Thanks in advance!!

topic Restoration in QlikView