Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
I have the same problem with multiple xls files. Do you already found a solution ?