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: 
parpatra
Partner - Contributor III
Partner - Contributor III

Load all files from FTP

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

3 Replies
llauses243
Creator III
Creator III

Hi,

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

Good luck, Luis

parpatra
Partner - Contributor III
Partner - Contributor III
Author

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
Partner - Creator II
Partner - Creator II

Hi,

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