topic QlikView Partial Reload? in QlikView

QlikView Partial Reload?

Thu, 16 Apr 2009 01:24:14 GMT

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

QlikView Partial Reload?

sna — Thu, 16 Apr 2009 01:31:03 GMT

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

QlikView Partial Reload?

Oleg_Troyansky — Thu, 16 Apr 2009 03:21:32 GMT

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

QlikView Partial Reload?

Thu, 16 Apr 2009 19:38:29 GMT

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

QlikView Partial Reload?

Thu, 16 Apr 2009 21:59:53 GMT

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

QlikView Partial Reload?

prieper — Sat, 18 Apr 2009 03:57:21 GMT

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.

Re: QlikView Partial Reload?

Fri, 26 Apr 2013 09:37:39 GMT

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

Regards,

Snehal Nabar

Re: QlikView Partial Reload?

Fri, 26 Apr 2013 13:47:52 GMT

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.