Often in a Qlik Sense application, we need to load data from a directory that contains an identical set of data files; for example, sales for each country come in different files for each month. In such a case, we use a wildcard load, in order to fetch the data for our application. The following recipe discusses the data modeling issues encountered when using the wildcard load and how we make use of the For each
loop structure in the script to overcome this issue.
For this exercise, we will make use of two sample XLSX files, namely, Apr2015.xlsx
and May2015.xlsx
, that contain mock sales data for six countries. These files can be downloaded from the Packt Publishing website.
- Once the source files are downloaded, store them in a folder called
ForEachLoadData
. - Create a folder connection as explained in Chapter 1, Getting Started with the Data, that points to the
ForEachLoadData
folder. Name the connection asQlikSenseCookBookForEachLoadData...