topic reload parcial script in QlikView

reload parcial script

Sat, 31 Oct 2009 16:46:03 GMT

Hello QV friends,
please I need yo know this:
Is it possible to reload parcial block of SQL sctipt?
example
tab1:
load.... select ...from ..;

tab2:
load.... select ...from ..;

tab3:
load.... select ...from ..;

tab4:
load.... select ...from ..;

If I reload the qvw document the applications loads all table.
Now. I need to knos if is it possible, to reload just a table 3
(tab3)..

Thanks for your always prompt replay.
Best Regards

Slash

disqr_rm — Sun, 01 Nov 2009 00:29:16 GMT

Yes this is possible with partial reloads. Have a look in the help for ADD and REPLACE keywords combined to LOAD statement.

Mon, 02 Nov 2009 16:52:34 GMT

Yes, you can use add keyword prefixeing load keyword in tab3 this

tab1:
load.... select ...from ..;

tab2:
load.... select ...from ..;

tab3:
ADD load.... select ...from ..;

tab4:
load.... select ...from ..;

And reload using CTL+Shift+R

Mon, 02 Nov 2009 19:48:45 GMT

Use 'Add' or 'Concatenate'.