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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
jjustingkm
Creator II
Creator II

load qvd's

How to load data from QVD in qlik. looking to load all the tables from all the available qvd's in the folder.

Thanks,

Labels (1)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can use a wildcard in your Load FROM clause. For example:

From lib://mydata/folder/*.qvd (qvd);

-Rob

View solution in original post

2 Replies
_Iswarya_
Contributor III
Contributor III

@jjustingkm 

Set vFolder = 'D:\Folder\QVD';

for each File in filelist(vFolder& '\*.qvd')

     load *  from [$(File)] (qvd);

next File

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can use a wildcard in your Load FROM clause. For example:

From lib://mydata/folder/*.qvd (qvd);

-Rob