Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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