topic load multiple CDV files from ftp Directory in QlikView

load multiple CDV files from ftp Directory

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: load multiple CDV files from ftp Directory

YoussefBelloum — Wed, 08 Nov 2017 15:14:30 GMT

Hi,

it is loading some files when you put * ? or it is blocking from the start ?

Re: load multiple CDV files from ftp Directory

marcus_sommer — Wed, 08 Nov 2017 17:30:35 GMT

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

Re: load multiple CDV files from ftp Directory

Anonymous — Wed, 08 Nov 2017 18:12:00 GMT

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.

Re: load multiple CDV files from ftp Directory

Anonymous — Wed, 08 Nov 2017 18:13:16 GMT

Hi Marcus,

Thank you for your answer. I´ll check the link you sent.

Best Regards.