Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to reload only one data tab in a qvw file

Hi All,

I have a qvw file which pulls some data from another qvw file which is saved on a network path of different geographical location. Now this qvw file has multiple tabs in it and when I reload the file it pulls the data for all the tabs from the another qvw file (which I have mentioned above). Now as the file is located on a remote server it takes too long for me to reload my qvw file. Some times I want the data to be reloaded only one data tab of my qvw but still I need to reload the entire file. Do we have any way by which I can reload only one data tab of my qvw file. Any shortcut or code which can do this for me ?.

Thanks a lot for your help in advance.[:)]

1 Reply
prieper
Master II
Master II

You may use "Partial Reload" in order to preserve some data loaded from other - remote - locations, script might look somehow like the below:

DROP TABLE MyLocalTable;
MyLocalTable: ADD LOAD * FROM .....;
EXIT SCRIPT;


Script to be invoked either manually from File-Menu or in batch-mode. Usually all data will be purged before the execution of a new reload, with partial reload, all data will remain and you need to expressively either delete existing tables (or fields etc) and preceed creation of a new table with the keyword "ADD".

HTH
Peter