topic Re: Partial reload - Drop table error in QlikView

Partial reload - Drop table error

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Partial reload - Drop table error

sunny_talwar — Thu, 27 Apr 2017 14:35:50 GMT

Can you share the script you are using?

Re: Partial reload - Drop table error

prieper — Thu, 27 Apr 2017 15:33:23 GMT

DROP TABLE3;

TABLE3:

ADD LOAD * FROM ......;

EXIT SCRIPT;

REPLACE does not always seem to work. ADD is important.

HTH Peter

Re: Partial reload - Drop table error

Tue, 02 May 2017 09:49:21 GMT

Hi all,

my script is very big but I have attached a sample of the script following the same principle.

I am trying to partial reload todays date from Calendar and partial reload the data from Customer_table.

I have added REPLACE to the Calendar and Customer tables.

but I am not sure why is it coming with an error with the Drop of the sales table even though I am renaming the Temp to Sales.

Re: Partial reload - Drop table error

sunny_talwar — Tue, 02 May 2017 11:06:32 GMT

So this is the only table you are looking to partially reload?

[CustomerServices_Temp]:

REPLACE LOAD *,

DATE (Date_column) AS %DOF,

;

SQL

SELECT

FROM

Customer_Table

If that's true, then may be do something like this

IF NOT IsPartialReload() THEN

Your script which doesn't have to be partially reloaded

ENDIF

IF IsPartialReload() THEN

[CustomerServices_Temp]:

REPLACE LOAD *,

DATE (Date_column) AS %DOF,

;

SQL

SELECT

FROM

Customer_Table;

ENDIF

Re: Partial reload - Drop table error

Thu, 04 May 2017 13:19:43 GMT

Hi All,

Thank you for your help with this.

Sunny: I have tried that but unfortunately the data reloads only ifpartial reload, and I want the customer table to reload both in partial reload and full reload.

Re: Partial reload - Drop table error

sunny_talwar — Thu, 04 May 2017 13:24:39 GMT

Then try this

[CustomerServices_Temp]:

REPLACE LOAD *,

DATE (Date_column) AS %DOF,

;

SQL

SELECT

FROM

Customer_Table

If that's true, then may be do something like this

IF NOT IsPartialReload() THEN

Your script which doesn't have to be partially reloaded

ENDIF

IF IsPartialReload() THEN

[CustomerServices_Temp]:

REPLACE LOAD *,

DATE (Date_column) AS %DOF,

;

SQL

SELECT

FROM

Customer_Table;

ENDIF

Re: Partial reload - Drop table error

ramasaisaksoft — Thu, 04 May 2017 14:27:58 GMT

Hi Amir,

unable to open your application because of License issue.

may be the below code will help to you .

It's worth noting that ADD and REPLACE loads are executed in both normal and partial reloads, unless you use the ONLY qualifier, to make the ADD or REPLACE take place only if a partial reload has been executed. So

Customers:

REPLACE LOAD *

FROM Customers.qvd (qvd);

Will work always, removing the table Customers and replacing it by the records in the QVD file, whilst

Customers:

REPLACE ONLY LOAD *

FROM Customers.qvd (qvd);

Will only be loaded if the execution was partial, but not when the reload is normal.

Hope that makes the thing easier to understand.

Re: Partial reload - Drop table error

Fri, 05 May 2017 11:40:44 GMT

Sunny: Thank you ever so much for your help that resolved my issue

Re: Partial reload - Drop table error

Fri, 05 May 2017 14:09:00 GMT

Hi Sunny:

Would you please explain how does this function work? and would the Drop table function work with Partial Reload? any idea?

Much appreciated

Re: Partial reload - Drop table error

sunny_talwar — Sun, 07 May 2017 22:15:42 GMT

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

Author ‒ QlikView

Re: Partial reload - Drop table error

Mon, 08 May 2017 08:06:30 GMT

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

Re: Partial reload - Drop table error

sunny_talwar — Mon, 08 May 2017 09:27:30 GMT

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.