store all the data model in a qvd

[Anonymous]

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

[quwok]

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]

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]

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;