Dear all,
I want to load all excel files of a folder automatically. I found a script that should work:
For each file in FileList('C:\Temp\Reports\*')
TEMP_FILE:
LOAD
subfield('$(file)','\',-1) as filename,
FileTime('$(file)') as Date_file autogenerate 1;
Next;
But the FileList stays empty. Qlik is running on a server and the folder on the server is not empty.
If I debug the code, the step jumps directly from for each to next.
Can someone help?
