Just wondering about few things regarding the QlikView operation. When we update with new script and tab, can we just re-load the updated one while leaving the old one?

[Anonymous]

Example:  Data Loader Script has few tabs example (ETUS,FDUS,COUS,SST, FM & MS). Suppose we added FM& MS recently and want only to execute those new one. Is that possible?

If yes could you please explain the procedure. Which will save some time for re-execution for the same thing again and again.

Thanking you in advance.

Best Regards,

Shubham Kumar

[siva_boggarapu]

Hi Shubham,

You can use an if statement together with variables to select which parts of the load/select script to execute.

If you create variables for each product with a value of 0 or 1 you can use this value together with IF to execute parts of the script.

Example:

set loadetus = 1;

if($(loadetus)<>0) then
       SELECT 
        OU_Pnr_id,
        OU_PnrLeg_id,
        OU_Airline,
        OU_BaseClass,
        OU_FromAirRegion

        …

FROM         dbo.OverUnder_history with (nolock)...  end if

Let me know if you have any questions.

[kaushiknsolanki]

Hi,

   All you need to do is add, "ADD" keyword before the load statement in your new tab.

   And do the partial load.

   It will load only the tables which have Add, Replace prefix with load statement.

   For more information about Partial load, Look into Qlikview Help.

   Hope this will help you

Regards,

Kaushik Solanki

[#4]

Hi Shubham,

If you are uploading a new data/ scripts and you dont want to run the whole script you can try partial load of the dtat you newly updated. In qlikview there is an option in file tab called Partial load where it loads the newly added script / data give a try to it if it didn't worked let us know to sort a new solution for your problem.

Thanks a lot

Bradd