Script error while loading multiple files

[ArjunPrasad]

HI All,

i am trying to load multiple excel sheets using for each loop . but giving error like below

what is the issue not able to figure out.

PFB script

For each vFile in FileList ('lib://Files/*.xlsx')
CountrySales:
LOAD *,
Left(Source,3) as Month;
Load
Country,
Sales,
Filebasename() as Source
from [$(vFile)]
(ooxml, embedded labels, table is Sheet1);
Next vFile;

Can you suggest me the solution.

Thanks

Arjun

[Chanty4u]

did you tried checking this?

https://community.qlik.com/t5/QlikView-App-Development/Loading-Multiple-Excel-files-to-QlikView/td-p...

or this

https://community.qlik.com/t5/New-to-QlikView/Load-multiple-excel-files-from-Multiple-excel-sheetsin...