Load * FTP

[Anonymous]

Guys,

I'm trying to load a csv file from an ftp, but I'm getting an error that the file cannot be opened. This is te code I'm using:

Set tabla = 'Prueba';

$(tabla):

LOAD * FROM

ftp://user_name:password@server_ip/file_name.csv;

STORE $(tabla) into $(PathQvd)$(table).qvd;

Thanks,

JAS

[kiranmanoharrode]

Hey Mate,

Use Qlik Web connector for fetching data from FTP Server. FTP/SFTP connector is free in the package.

For fetching all files (*) use for loop with variables.

I hope the connector helps you to achieve requirement.

Link

Thanks.

Kiran

[marcus_sommer]

Your load-statement missed a fileformat for the csv like:

...

LOAD * FROM ftp://path/file_name.csv (txt, ansi, no labels) ;

...

To find the right fileformat for your file just use the file-wizard.

- Marcus