Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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