topic Re: Is it possible to store a QVD during a partial load? in App Development

Is it possible to store a QVD during a partial load?

rnorris — Wed, 20 Dec 2023 15:59:02 GMT

I have some code that says:

[A Sessions Link]:
LOAD

1 as dummyrow

Autogenerate(1);

IF IsPartialReload() THEN

[A Sessions Link]:

ADD ONLY LOAD

'Name' AS _ASessionName

AutoGenerate(1);

Store [A Sessions Link] into [$(Folder)/SessionsLink.qvd];

END IF;

So, I create a table during regular load (so it does already exist for the add only) but when I run the partial reload, I see a field in my dashboard called _ASessionName populated with 'Name', great.

I also get a QVD generated, with the right name in the right place. Great!

But the QVD only has one column, dummyrow.

The partial reload has loaded the data into the table, but stored the prior table. Is this right? This seems very counterintuitive / wrong? (Note: It does exactly the same thing with REPLACE ONLY LOAD too, so, no, it's not that!)

Re: Is it possible to store a QVD during a partial load?

rwunderlich — Wed, 20 Dec 2023 17:53:41 GMT

On the second load, you will need to change the table label to Concatenate.

Concatenate ( [A Sessions Link])
ADD ONLY LOAD...

If you look in the data model without the concatenate, you'll see the table created by the second load was named "A Sessions Link-1". You must force concatenation with the first table by using the Concatenate prefix.

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: Is it possible to store a QVD during a partial load?

rnorris — Thu, 21 Dec 2023 09:54:02 GMT

Ah! Thanks Rob, I hadn't noticed it doing that, I'll check this out.

So does this mean that with ADD ONLY you would always need Concatenate as well? Since ADD wont create a table during partial load and only will only execute during one?

Re: Is it possible to store a QVD during a partial load?

rwunderlich — Sat, 23 Dec 2023 04:28:20 GMT

I think partial reload is subject to the same rules of auto concatenation as a regular load.

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/LoadData/concatenate-tables.htm

The Concatenate prefix is only required if you have unlike columns. Some developers always uses Concatenate, unlike columns or not, if the intent is to add rows to an existing table.

-Rob