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

adding new table without reloading the whole script?

Dear all,

I am working on a QVW at home,

I have no way to connect to the original data source(at my office\),

If i would like to add a new table onto the data model,

how to achieve this?

Many Thanks!

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

First use the QVWDataExtractor tool that you can find here to extract the data from your qvw document and store the tables in qvd files. Then make a copy of your document and replace the load statements with statements that load from the generated qvd files. Then add a load statement for your new table.


talk is cheap, supply exceeds demand
Not applicable
Author

Dear Wassenaar,

Thx for reply, but i still want to know, if there's any approach to add the table without extra effort(replacing almost all script),

that means only relaod a table and the the table will link up with the whole data set inside the QVW.

anyway, your answer really help^^

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Maybe a partial reload. Add a load statement for your new table:

ExtraTable:

REPLACE LOAD

   field1,

   field2,

   ...etc

FROM ...sourcetable...;

Then choose Partial Reload in the File menu instead of Reload.


talk is cheap, supply exceeds demand