Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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