How to create QVD files with fields from multiple tables?

[#1]

Hi there,

I understand it's possible to create a QVD file using STORE statement and load fields from one table to create a QVD file.

But is there a way to create a QVD file where the fields are coming from multiple tables?

If so I would be greatful if you could share how you do it

[simondachstr]

Only one table per QVD file. This means you will need to concatenate/join all your tables/fields into one before storing it into the file.

If you wish to save a whole data model in a file you will need to create a qvw for this purpose. You can then load this data modele by using the "binary load" function to import the data model. However note that you can only do a single binary load per application.

[#3]

You should load fields from multiple table  to a single table  according to your requirement Concatenate/Join.

Then restore that table into QVD file using Store command.

[#4]

Hi,

If the data load you're doing from a database (SQL, Postgres, etc) you can use JOIN uniting them into a single table with one or more fields in common, or if they are UNION tables with the same fields.

If the load is different from QVD, you can still use JOIN to join and form a single QVD file.

[jagan]

Hi Michael,

A QVD can store only one table data, if your data is in multiple tables then you have to use Join (Left/Right/Inner) or Concatenate the tables, then you can save the final table in QVD by using STORE command.

If you are loading data from database then in the query itself you can join the required tables and retrieve the fields you required.

Example:

Data:

LOAD

*

FROM Table1;

Left Join(Data)

LOAD

*

FROM Table2;

STORE Data INTO Data.qvd;

Regards,

Jagan.

[#6]

Create a SELECT JOIN statement - there is a PDF for JOINS and Lookups in the community