Discussion Board for collaboration on QlikView Scripting.
I have a problem loading all files of similar format (test_date.xls) from the FTP site. It works fine when I load files from the local drive.
LOAD *,FileName() as FILE_name
(biff, embedded labels, header is 2 lines, table is table$);
The error given is "Unable to open the file...."
However if I change the ‘not working’ code to individual files name (ex test_012010.xls), it works fine. It works for for all the indiviual data files.
Is the *.* not compatible while reading from FTP ?
Answer in thread http://community.qlik.com/message/120966#120966
Good luck, Luis
Thanks for the reply...but my problem is I am able to connect, but I am not able to fetch file names by using *.*
I can fetch the data by writing the exact file name, but not by using 'wildcard' from the FTP.
I have the same problem with multiple xls files. Do you already found a solution ?