I want QlikView script to read all those files from the folder and create QVDs with the same names as the Excels (File-Jan-2018.qvd, File-Feb-2018.qvd, File-Mar-2018.qvd....)
I would like to create the script in such a way that I don't have to write all the file names in the script; instead pull all the .xlsx files in the folder and create QVDs with the same names, sort of Dynamically.
set vRoot = '.';
FOR Each File in filelist ('$(vRoot)'&'\*.xlsx')
(ooxml, no labels, table is data);
let qvdname= replace(File,'xlsx','qvd');
store Temp into $(qvdname);
drop table Temp;