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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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