If I would like to perform data extraction in batch mode during off-peak period of network, I guess I have to schedule a script with LOAD statement and store it in .qvd files . I understand depending on datasource ( DB or Excel file) LOAD statement will vary. But how to schedule and invoke the script to perform data extraction ?
Yes it is possible. Go to window scheduler properties -->Scheduler -->Advanced & u can configure it as per your need, provided the script for loading hourly/daily/weekly data should be written in separate qvw other wise u need to have some flag so that daily script should not exec with hourly.....(if all script are in the same qvw)
In my case script is in same qvw and it contains huge data. So it will be pointless if reloaded all the data again and again. So I think its better to do incremental reload. Do you have any suggestion for this? Please guide me if you can
Actually qlikview mainly do the analysis for sales and Finance purpose which is typically starting from the daywise . And a very little no of customers like Sensex do need hourly or even minute basis report which should be dyanmically reloaded every time.
if your purpose is to have a clear analysis on hourly basis u should rather do incremental load it will take comparetively little time to load than whole datamodel again.
Many thanks for your reply. But tell me how to do incremental load if I don't have much knowledge with the tables I am working on as I am new to this work. What I mean to say is if I don't know PK of the table and also it doesn't have the modified date field. In this case on what basis I will do the incremental load.
But imagine if the year field is there with us. Let me know how it can be done?
Let me know which data do u have for an hourly basis calculation ..It need to have a field having time stamp. Rather how can u do the analysis on hourly basis unless and otherwise if u don't have houlry data(Timesatmp).