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: 
jjustingkm
Creator
Creator

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