Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm working on a project where the data source consists of excel sheets from several vendors posted to an FTP site, new documents are added to site monthly. Any ideas on the best approach to load these new sheets into a Qlik application?
*Using Qlik Sense Enterprise Edition
Thanks
It's best to a avoid such a data source. Excel and different parties involved feels like problems.
Hi,
You can do the same thing in Qlik Sense using a Web file connection, without the need to activate legacy mode.
In Qlik Sense 2.0:
1. Select Add data from the Menu (next to the Navigation button)
2. Select the Connect my data tab
3. Click Web file in the list of data source types
4. Enter the ftp address in URL, give it a Name and click the > button to continue
Now you should get into the Select data dialog to select fields, and then load.
As an alternative, if you use an old script, just create a Web file data connection in the Data load editor:
1. Select Create new connection, then Web file
2. Enter the ftp address in URL, give it a Name , for example FTP
3. Click Create
Now you have a Web file connection called FTP (your_user_name)
4. In the Load statement From part replace the FTP URL with [lib://FTP (your_user_name)]
LOAD
....
FROM [lib://FTP (your_user_name)];
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Rohit Kumar
Hi Rohit - the web file connection doesn't work, it returns an 'Unknown Error'.
Any suggestions for dealing with such scenarios where the client's core data source is spreadsheets?