Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
parpatra
New Contributor II

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
Contributor III

Load all files from FTP

Hi,

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

Good luck, Luis

parpatra
New Contributor II

Load all files from FTP

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
Contributor II

Load all files from FTP

Hi,

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

Community Browser