Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sep 19, 2022 8:53:25 AM
Sep 19, 2022 8:42:16 AM
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:
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
"
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.