Getting ready

When extracting the data from the FTP server:

  1. Open your web browser to check whether the URL is correct and whether you have access to the server (I prefer Firefox for this task).
  2. Insert the following URL from which you can see a list of folders and files from a local FTP server: ftp://qlik:pwd@localhost (change the URL with your credentials and server name):

  1. Navigate to the folder with the files you need:

  1. Right-click on the file and select Copy Link Location:

In my example, I chose ROUTE_BUS.csv:

  1. Open an existing Qlik Sense application or create a new one.
  2. Open the Data load editor.
  3. Click on Create new connection and select Web file.
  4. The Select web file window will open.
  5. Insert the URL copied from the web page to set a connection with the file to extract data: ftp://qlik:pwd@localhost/chapter%201/QlikSenseData/ROUTE_BUS.csv.
  6. Name the connection as QlikSense Cookbook FTP ROUTE_BUS, as shown in the following screenshot:

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset