Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
jasellhorn
New Contributor

Load * FTP

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

 

Labels (1)
2 Replies
kiranmanoharrode
Contributor III

Re: Load * FTP

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

MVP & Luminary
MVP & Luminary

Re: Load * FTP

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