Partial reload - Drop table error

[#1]

Hi all,

Would you please be able to help me with this?

I have a quite big dashboard pulling data from 2 to 3 different data sources, and in the script i'm using lots of links and Drop table and Rename statements.

I am trying to do a Partial Reload of one specific database source out of the 3. Is it possible ?

I have added a Replace Load on the tables that I want to have a Partial Reload, but I get an error with the Drop table statement.

Can you please advise on this?

[sunny_talwar]

Which function are you talking about? IsPartialReload? It just checks if the reload is partial reload or not... Read here:

Author ‒ QlikView

[#3]

Hi Sunny,

Ok I understand that, can you please advise if Drop table statement work with Partial Reload, because when I run a Partial Reload all Drop tables do not drop

[sunny_talwar]

Drop statement does work with partial reload, just make sure to have them outside of this part

IF NOT IsPartialReload() THEN

    Your script which doesn't have to be partially reloaded

ENDIF

Anything between this above IF NOT IsPartialReload statement and ENDIF won't get executed during a partial reload.