topic Load multiple QVD's into one QVD file in QlikView

Load multiple QVD's into one QVD file

ivandrago — Tue, 19 May 2015 13:22:32 GMT

Hi,

I have a folder (C:\Qlikview\) that contains multiple qvd's, within this folder I want to select only the QVD's that begin with the name Sales****.qvd and then put this into one QVD file called Master_Sales.qvd

Is this possible?

Thanks

Re: Load multiple QVD's into one QVD file

swuehl — Tue, 19 May 2015 13:27:29 GMT

A QVD will store only one table.

If all Sales***.qvd files show similar fields, e.g. just data for different months, you can create a QVD to LOAD all QVDs, concatenating them to a single table and STORE this single table to your master qvd.

Re: Load multiple QVD's into one QVD file

jsanchezh — Tue, 19 May 2015 13:27:38 GMT

Try this, if they have the same field names

Table_Master_Sales:

Load ...

...

From (qvd);

STORE Table_Master_Sales into C:\\Qlikview\Master_Sales.qvd

I hope it helps