Using the For Each loop to extract files from a folder

Picture a scenario where the month end sales data in an organization is stored in a folder on the network from where it needs to be picked up for reporting purposes. Control statements such as For Each next can be used in Qlik Sense as an approach toward script iteration. The following recipe deals with extracting files in Qlik Sense from a folder, processing them to create QVD files, and then transferring the source files to another folder. In the process, we will also deal with the incremental update of the QVD.

Getting ready

This recipe requires the legacy mode to be activated. The steps are as follows:

1. To activate the Legacy mode, open the Settings.ini file under C:\Users\<username>\Documents\Qlik\Sense.
2. Change the value of the StandardReload parameter from 1 to 0.
3. For this recipe, we make use of four Excel files: January.xlsx, February.xlsx, March.xlsx, and April.xlsx. These files are provided with the chapter and can be downloaded...