Qlik Sense Partial reload does not work with JOIN and DROP statements

Andreas_Giesbrecht — Mon, 19 Sep 2022 12:53:25 GMT

Please note that when you are using partial reloads including JOIN and DROP statements together in the same script, you might get an unexpected "table ... not found" error when executing the partial reload (most likely the full reload will be working without errors) like for example:

20220919T141809.123+0200 0043 Resident Temp_Fact
20220919T141809.123+0200 Error: Table 'Temp_Fact' not found
20220919T141809.123+0200 Execution Failed
20220919T141809.125+0200 Execution finished.

This behavior is caused due to a limitation for the partial reload. An according update in the documentation is planned to be released soon under the following link:

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/PartialReload.htm

If you still want to use DROP and JOIN statements in the same script you can try to apply the following code as workaround where you can see that the script is broken done in a partial reload and full reload section using IF statements :

// Partial Reload

TestPartialReload:
ADD ONLY LOAD 1 AS Dummy AUTOGENERATE 1;
LET vPartialReloadLength = NoOfRows('TestPartialReload');
LET vPartialReload = IF (Len('$(vPartialReloadLength)')>0, 'Partial', 'Full');
Trace '$(vPartialReload)';
IF '$(vPartialReload)' = 'Partial' THEN

//insert in here the partial reload script

...

DROP TABLE TestPartialReload;
ENDIF

//then in the script use
IF '$(vPartialReload)' = 'Full' THEN

//insert in here your full reload script

...

ENDIF

Environment

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

article Qlik Sense Partial reload does not work with JOIN and DROP statements in Official Support Articles

Qlik Sense Partial reload does not work with JOIN and DROP statements

Environment