Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I saw several solutions here in the forum but they didn't work. I want to read several files in a directory but it don't works:
for each file in filelist('lib://myPath/Archive\*.xlsx')
LOAD
ID,
Title
FROM [$(file)] (ooxml, embedded labels, table is default_1)
NEXT file
This should work.
Are you able to load one the file of this path, like?
LOAD
ID,
Title
FROM [lib://myPath/Archive\onefileofthefolder.xlsx] (ooxml, embedded labels, table is default_1)
Hi, @QlikSensor
Is the file directory path you want to connect to valid?
And does every Excel file have a default_1 worksheet?
Reply! thanks!
Yes, the directory is correct. I loaded just one file manually via the menu and then adapted the script.
When you say this doesn't work, do you have any error messages? Could you check if Qlik is entering in the loop using Trace for example?