topic Re: Partial reloading without erasing in memory data in QlikView

Partial reloading without erasing in memory data

sibrulotte — Mon, 07 Oct 2019 13:37:02 GMT

Hi,

I noticed that when I reload a document that has a table in it (call it Segmentation_TMP), if I do a load * resident Segmentation_TMP , it cannot find the table. IS it a normal behaviour that Qlikview wipes the tables in-memory before loading the script?

That table was loaded from an SQL script, and I don't want that SQL connection to run evey load.

So I do an IF on a partial reload like so:

IF IsPartialReload() = 0 THEN

OLEDB CONNECT TO ***SQL CONNECTION***

Segmentation_TMP:
SQL SELECT *
FROM A TABLE IN OUR SQL SERVER
;

else

Segment_PL:
load
NAP_INDIVIDU as NAP_PL

resident Segmentation_TMP;

But ALAS, that second table never loads, and doesn't show an error message.

Re: Partial reloading without erasing in memory data

martinpohl — Mon, 07 Oct 2019 13:43:27 GMT

hi,

when start a reload as partial reload, only load statements with a prefix

replace or add

are executed

see this

https://help.qlik.com/de-DE/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/Replace.htm

regards

Re: Partial reloading without erasing in memory data

ljackson — Mon, 07 Oct 2019 15:03:49 GMT

Check to see if your script drops the resident table. Is it just a temporary table?

Use 'Add Load' before the creation of the resident table, and make sure this table is not dropped further in the script, then the partial reload will pick it up

Hope this makes sense

Re: Partial reloading without erasing in memory data

Brett_Bleess — Mon, 14 Oct 2019 14:21:53 GMT

Simon, did either of the posts help you get things working as you expect? If so, be sure to come back and use the Accept as Solution button on the post(s) that helped. If you did something else, consider posting that and then mark things as above, and if you are still working on things, let us know where you stand, and we can see if we can come up with something else. Might be good if you can attach the QVW on this one potentially, so folks can see the entire script and resulting data model to see if there is something quirky going on with things.

Regards,
Brett