topic Re: How to create QVD files with fields from multiple tables? in QlikView

How to create QVD files with fields from multiple tables?

Thu, 14 Aug 2014 22:01:48 GMT

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

Re: How to create QVD files with fields from multiple tables?

simondachstr — Thu, 14 Aug 2014 22:11:12 GMT

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.

Re: How to create QVD files with fields from multiple tables?

Thu, 14 Aug 2014 22:29:00 GMT

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.

Re: How to create QVD files with fields from multiple tables?

Thu, 14 Aug 2014 23:30:59 GMT

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.

Re: How to create QVD files with fields from multiple tables?

jagan — Fri, 15 Aug 2014 03:10:26 GMT

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.

Re: How to create QVD files with fields from multiple tables?

Fri, 15 Aug 2014 03:23:33 GMT

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