Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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