topic Load all files from FTP in QlikView

Load all files from FTP

parpatra — Mon, 07 Nov 2011 18:36:48 GMT

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

Load all files from FTP

llauses243 — Mon, 07 Nov 2011 20:18:21 GMT

Hi,

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

Good luck, Luis

Load all files from FTP

parpatra — Mon, 07 Nov 2011 21:00:44 GMT

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

Load all files from FTP

francisvandergr — Mon, 13 Feb 2012 14:14:44 GMT

Hi,

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