Loading a data file from data files (QlikCloud)

In the Loading a data file from a folder (Qlik Sense Desktop) section, we learned how to load data into the Qlik Sense Desktop application. QlikCloud has a special repository for the data files. In this section, we are going to continue with the exercise for QlikCloud:

  1. The repository for data files can be accessed through the QlikCloud hub using the Import data option, as shown in the following screenshot:

  1. The Import data button on QlikCloud will give you the option to upload one or more files by dragging them into the gray area, or selecting them using the Choose file option:

  1. Upload your Customers.txt file and, then press the Done button:

  1. Go back to the application and press the Data button at the top of the screen:

  1. There is a big circle representing the Orders table, along with a big + on the upper-left corner. Press the circle, as follows:

  1. The screen will now show all the connectors. Currently, we are interested in the option on the left-hand side called Data files, which gives Qlik access to the files that have been uploaded:

  1. Select the Customers.txt. From there, then you will be prompted with a screen just like this: 

  1. Qlik Sense automatically tries to identify how your data file is structured. Qlik Sense has inferred that the file has spaces as a field delimiter. We know that the delimiter is a comma, so we change the way Qlik Sense will split the lines by changing the Delimiter option to Comma, as we can see in the following screenshot, and instruct Qlik Sense to use the Embedded field names for Field names and check all columns:

  1. We now have a proper view of our data. After pressing the Add data button, we're going to see a screen just like this:

Now, we have two tables (represented by two circles). When you click on a circle, a preview of that table is shown, like in the previous screenshot. As you can see, we have five options for each selected table:

  • Edit the selected table.
  • Reload the data from the selected table.
  • Delete the selected table from our model.
  • Clear filters (if you have applied any filter when loading your table). If you don't have any filters, this buttons is disabled.
  • More options (concatenate tables and view details).
..................Content has been hidden....................

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