Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

execute store statement only on non-partial reload

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.

1 Solution

Accepted Solutions
Not applicable
Author


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


View solution in original post

4 Replies
Not applicable
Author


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


Not applicable
Author

That should really be:

If not IsPartialReload() then

...

stephencredmond
Luminary Alumni
Luminary Alumni

Hi,

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

Stephen

Not applicable
Author

Thanks a lot, Tim and Stephen.

It works perfect!