QlikView Partial Reload?

[#1]

Hi,

We are running QlikView version 8.0 and I am trying to run a partial reload on a document. As I understand it, a partial reload only executes select statements of the script that are preceded with REPLACE or ADD. The document that I am working with will attempt to load sections that are NOT preceded with REPLACE or ADD.

Any help would be greatly appreciated.

Thanks!

Keith

[sna]

Just to be safe, I have to ask an obvious question first. Are you doing the partial reload from File - Partial Reload, not the regular "Reload"?

Also, as far as I know, it executes JOINs and DROP fields/tables.

Shima

[Oleg_Troyansky]

As a general suggestion, I'd recommend to stay away from partial reload. It's a rudiment from the past and as a good practice, should be replaced by incremental load using QVD files.

You can spend a lot of time trying to understand what went wrong and why, using partial reload...

good luck!

Oleg

[#4]

Shima,

Thank you for the reply. Yes, I'm doing the File->Partial Reload.

For a little background; we are using saved archival documents as historical sales "snapshots", which obviously cannot be completely reloaded. I was trying to do a partial reload on just the security (user tables) to allow someone access to the document that was not in the security table the last time the document was fully reloaded. But, the attempt was made to reload a couple of the other tables in the script.

From another reply it sounds like the partial reload is not a good idea anyway.

Thanks again,

Keith

[#5]

I recall a keyword ONLY in the ADD syntax -- I think you need it to limit the add to partial reloads.

[prieper]

I do not think that the partial reload can change something in the access-restrictions.

Partial reload makes sense during the testing of the script, where you want to avoid some time-consuming reload of the entire data, just for adding one more table.

[#7]

Hi

Partial reload executes a specific part of your sciprt, which will refresh a certain table.

Regards,

Snehal Nabar

[#8]

I know this is an old post but here are my two pennies. Partial reload still executes every line of code in your script apart from load statements that are not prefixed with ADD or REPLACE.

E.g. adding the following script to the start of your document and running a normal reload will just add the new table TEST1 as any normal reload would, the IsPartialReload catches the reload type and won't perform the action insode the IF statement. running a partial reload will then amend the data in the table TEST1 add a new table TEST2 and exit the script from the partial load leaving the rest of the data model as it was before the reload.

TEST1:

LOAD * INLINE [
    Ex1, Ex2, Ex3, Ex4
    1,A,D,G
    2,B,E,H
    3,C,F,I];

if(IsPartialReload()=-1) THEN

Drop Field Ex2;
Drop Fields Ex3, Ex4 from TEST1;
Rename Field Ex1 to Example1;
Rename table TEST1 to Example1;

TEST2:
ADD ONLY LOAD * INLINE [
    TEST2
    1
    2
    3];

EXIT SCRIPT;
END IF 

This is all well and good but the downside to this is it may work for e.g. adding users to section access without a full reload but it won't work if you also use data reduction with your section access.