Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;