Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
juanregueira
Contributor II
Contributor II

load multiple CDV files from ftp Directory

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.

4 Replies
YoussefBelloum
Champion
Champion

Hi,

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

marcus_sommer
MVP & Luminary
MVP & Luminary

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

juanregueira
Contributor II
Contributor II
Author

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.

juanregueira
Contributor II
Contributor II
Author

Hi Marcus,

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

Best Regards.