topic Re: Run script reload to new code only in QlikView

Run script reload to new code only

Wed, 12 Mar 2014 21:19:19 GMT

Hi,
My QVW reads data from many QVD's. I have copied QVW into my PC from server and added new code to it and now I want to reload to take effective only newly added code while keeping existing data as it is. I know it is possible, but dont know the commands/required code changes.

Appreciate your input.

Cheers,

Laks

Re: Run script reload to new code only

Josh_Good — Wed, 12 Mar 2014 21:49:14 GMT

You are looking for the partial reload function. File->Partial Reload. Note you need to add the "Replace" function to your script in the places you want to reload.

You may also want to consider using a binary load for the load data model. That may be easier than adding "Replace" all over the place in your script.

Re: Run script reload to new code only

Clever_Anjos — Wed, 12 Mar 2014 21:52:13 GMT

Two options:

1)You should copy your QVD´s to your development workstation

2) Copy your app to a new one. Open this app, erase your script and include into very first line

binary [Path\yourqvw.qvw]

add your new code here

Re: Run script reload to new code only

Wed, 12 Mar 2014 22:20:11 GMT

I guess this is what I'm looking for.. I added new tab in the end and added LOAD statement like REPLACE LOAD>>..and tried to run File->Partial Reload, but it is still looking for prior LOAD ..or QVDs.

Here is the scenario..

Original file that I copied from server..

LOAD * from customer.qvd;

Modified file

LOAD * from customer.qvd;

REPLACE LOAD * from location.csv; // added

I want run reload for the modified file without having customer.qvd

cheers.

Re: Run script reload to new code only

Josh_Good — Thu, 13 Mar 2014 15:00:59 GMT

Try naming the tables and using the replace statement.

Customer:

Load * from customer.qvd;

Location:

Replace

Load * from location.csv;