Create A QVD From A Resident Join

RMMFCA — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am running into a small issue and can't understand why it is happening. In the data editor, I have the following piece of code that fails...

Union:
LOAD * RESIDENT [MKTDefn_201808];
LEFT JOIN
LOAD * RESIDENT [FCA_MARS];
STORE Union INTO [lib://DNA_Folder/QVD_RAFAL/Registration.QVD] (QVD);
DROP TABLE Union;

I have other things processing before this piece of code, but this is where it fails. The error I receive is...

The following error occurred:
Table 'Union' not found
The error occurred here:
STORE Union INTO [lib://DNA_Folder/QVD/Registration.QVD] (QVD)
Data has not been loaded. Please correct the error and try loading again.

Can't you store containers from memory into a QVD? Thanks in advance!

Re: Create A QVD From A Resident Join

m_woolf — Thu, 06 Dec 2018 17:37:09 GMT

You probably need:

Union:
Noconcatenate
Load ....

topic Re: Create A QVD From A Resident Join in QlikView

Create A QVD From A Resident Join

Re: Create A QVD From A Resident Join