Discussion board where members can get started with QlikView.
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';
LOAD * FROM
STORE $(tabla) into $(PathQvd)$(table).qvd;
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.
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.