Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ivandrago
Creator II
Creator II

Load multiple QVD's into one QVD file

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

1 Solution

Accepted Solutions
jsanchezh
Partner - Creator
Partner - Creator

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

View solution in original post

2 Replies
swuehl
MVP
MVP

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.

jsanchezh
Partner - Creator
Partner - Creator

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