Load all files from FTP

[parpatra]

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.

Working:

LOAD *,FileName() as FILE_name

FROM

(biff, embedded labels, header is 2 lines, table is table$);

Not Working

LOAD *,FileName() as FILE_name

FROM

[ftp://test:test@ftp.site.com/TEST/TEST_*.*test@ftp.site.com/TEST/TEST_*.*]

(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 ?

Thanks

[llauses243]

Hi,

Answer in thread http://community.qlik.com/message/120966#120966

Good luck, Luis

[parpatra]

Hi 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.

Thanks

Partha

[francisvandergr]

Hi,

I have the same problem with multiple xls files. Do you already found a solution ?