topic Re: adding new table without reloading the whole script? in QlikView

adding new table without reloading the whole script?

Fri, 04 Oct 2013 15:36:10 GMT

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!

Re: adding new table without reloading the whole script?

Gysbert_Wassenaar — Fri, 04 Oct 2013 15:41:11 GMT

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.

Re: adding new table without reloading the whole script?

Sat, 05 Oct 2013 05:19:52 GMT

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^^

Re: adding new table without reloading the whole script?

Gysbert_Wassenaar — Sat, 05 Oct 2013 06:53:24 GMT

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.