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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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