Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
japhias
Contributor II
Contributor II

Filelist is empty

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?

0 Replies