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