Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

store all the data model in a qvd

Hi,

I know hot to store a resident table in a qvd, but..is it possible to store the whole resident data modelo (10 tables for example)?

Thanks

4 Replies
quwok
Creator III
Creator III

Each QVD can only contain one table.

You could merge all data into a single table and save that into a QVD, but this usually is more hassle than it is worth. And it does not maintain the data model.

Alternatively, you could store it all in a QVW file and binary load the QVW file.


qlikmsg4u
Specialist
Specialist

Instead of QVD you can store all Data model into another QVW..

sunny_talwar

Why don't you use a Binary load, instead of using a qvd. The Binary load will keep your data model intact.

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

You can Concatenate all your tables into 1 table and store the table as 1 QVD.

If you want to identify the original table source, just hard-code the table name and alias it as SourceTable

Tab1:

LOAD

1

,2,

'Tab1'          AS SourceTable

from ABC;

CONCATENATE

Tab2:

LOAD

1

,2,

'Tab2'          AS SourceTable

from ABC;

CONCATENATE

Tab3:

LOAD

1

,2,

'Tab3'          AS SourceTable

from ABC;

STORE Tab1 into blahblah;