topic Re: Load * FTP in QlikView

Load * FTP

Anonymous — Sat, 16 Nov 2024 21:51:20 GMT

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

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

Thanks,

JAS

kiranmanoharrode — Tue, 20 Nov 2018 23:21:49 GMT

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.

Thanks.

Kiran

marcus_sommer — Wed, 21 Nov 2018 07:59:06 GMT

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