Discussion Board for collaboration on QlikView Scripting.
this code works:
For each File in FileList('C:\T\*.xlsx');
(ooxml, embedded labels, table is Sheet1);
this code gives me an error:
SET Tpath = 'C:\T\*.xlsx';
For each File in FileList($(Tpath));
Go to Solution.
For each File in FileList('$(Tpath)');
May be use directory loop instead of filelist to do this
Create a QlikView File Loop to Load all Files
Also, look at example number 2 here:
For each..next ‒ QlikView
I believe the code posted by Kaushik can solve your problem. You need to provide the variable inside single inverted i.e. FileList('$(Tpath)').
So if your problem is solved, please marked the answer as "Correct Answer".