Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
RMMFCA
New Contributor

Create A QVD From A Resident Join

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! 

1 Solution

Accepted Solutions
mwoolf
Honored Contributor II

Re: Create A QVD From A Resident Join

You probably need:

Union:
Noconcatenate
Load ....

1 Reply
mwoolf
Honored Contributor II

Re: Create A QVD From A Resident Join

You probably need:

Union:
Noconcatenate
Load ....

Community Browser