Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Amarmurakonda
Contributor
Contributor

it is possible to create qvd by using list

 
1 Reply
Tanalex
Creator II
Creator II

Yes, check out Mayuresh_d's response:

https://community.qlik.com/t5/QlikView-App-Dev/Multiple-Excel-file-load-and-save-each-to-qvd/m-p/125...

 

for each vFile in FileList('..\*.xlsx')

     TableName:

     load

          '$(vFile)' as SourceFile,

           FileDir() as Dir,
              FileName() as File_Name

     from [$(vFile)]

     (ooxml, embedded labels, table is Sheet1);

 

STORE Table Into 'D:\EDMS\'$(vFileName)'.qvd';
Drop table TableName;