How to load multiple xls files in script

[gshockxcc]

Hi,

     I am VERY new to Qlikview, and I don't fully understand all of the scripting functions.  So I'm really struggling to understand how to load multiple xls files.  I did quite a bit of searching here, and I have only been able to find this link that is somewhat relevant.  When I copy that code into my script editor, I get errors that I don't know how to debug. 

I have loaded a single table, so I am somewhat familiar with how to build the script  But I don't know how to do this for all files in a directory. 

Any help would be greatly appreciated.

Thanks,

[stevedark]

Hi,

The code looks fine, so my best guess is that the file mask and path does not match any source files.

Check that files exist which match E:\Final Data\FAN_*.xlsx

You can also use Debug mode in the load script to see where exactly code execution is going.