Previously, we learned how to load data by dragging and dropping our files onto the Qlik Sense application. In this section, we are going to continue the exercise, as follows:
- Press the Data button that lies at the top of the screen:
- There is a big circle representing the Orders table, along with a big + at the upper-left corner. Here, press the circle:
- The screen will now show all the connectors. Currently, we are interested in the option on the left-hand side, FILE LOCATIONS, which gives Qlik access to the folders on your machine:
- Using the FILE LOCATIONS option, navigate up to where you have downloaded your files and select the Customers.txt file. You will then be prompted with a screen like this:
- 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:
- Now that we have a proper view of our data, press the Add data button. From here, we're going to see a screen just like this:
Now, we have two tables (represented by two circles). When you click on one of the circles, a preview of the table it represents is shown in the bottom panel. As you can see on the bottom menu, we have the following 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).