Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
I´ve been strugling for the last two days with how can I load multiple CSV files from a given FTP directory and concatenate them into a table.
If I load a specific filename, I can load it without any problem, but as soon as I use a star simbol to load every file with the same name (except for the date) it fails.
For example..
This Works:
Load * from
'ftp://MyFTPUser:FTP_Password@IP_Address/Directory/Specific_File_Name.csv'
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
This doesn´t:
Load * from
'ftp://MyFTPUser:FTP_Password@IP_Address/Directory/BR*.csv'
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
Any Ideas?
Thanks in advance.
Hi,
it is loading some files when you put * ? or it is blocking from the start ?
It's not possible to use wildcards by FTP - you will always need a full-path or a batch-transfer, see: Re: Load new documents.
- Marcus
Hi Youssef, Thank you for your answer.
It´s blocking from the start.
I get a message sayinn that the file(?) could not be opened. Seing Marcu´s message below, ti should be some incompatibility between FTP protocol and wildcards.
Best Regards.
Hi Marcus,
Thank you for your answer. I´ll check the link you sent.
Best Regards.