topic execute store statement only on non-partial reload in QlikView

execute store statement only on non-partial reload

Mon, 14 Sep 2009 23:20:48 GMT

Hi all

We're creating a QVD file using STORE statement in non-partial reload. After that, we do a partial-reload to add new tables (we use "replace only" statement). The STORE statement executes again on partial-reload.

I've looked into the reference manual and it says only "store" or "add" statements are executed on partial-reload, but STORE is executing and updating data on QVD file... How could I ignore the STORE statement on the partial-reload?

I've attempt creating a temporary table, store temporary table into QVD and drop that table on "normal" reload, but it causes execution error during partial-reload.

Thanks.

execute store statement only on non-partial reload

Tue, 15 Sep 2009 00:06:04 GMT


If IsPartialReload() then
 Store mytable into myfile.qvd;
End If

execute store statement only on non-partial reload

Tue, 15 Sep 2009 00:07:33 GMT

That should really be:

If not IsPartialReload() then

...

execute store statement only on non-partial reload

stephencredmond — Tue, 15 Sep 2009 00:07:45 GMT

Hi,

Use the IsPartialReload() command within an IF..END IF to control the STORE.

Stephen

execute store statement only on non-partial reload

Tue, 15 Sep 2009 02:59:04 GMT

Thanks a lot, Tim and Stephen.

It works perfect!