Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Which function are you talking about? IsPartialReload? It just checks if the reload is partial reload or not... Read here:
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
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.