Is it possible to store a QVD during a partial load?
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!)
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.
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?
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.
