In Chapter 1, Getting Started with the Data, we learned how to activate the legacy mode and leverage the use of the EXECUTE
statement to run a windows command-line statement to create a copy of a file. The following recipe explains the steps to run a command line using load script variables as a parameter.
The files required for this recipe that are downloaded from the Packt Publishing website come in a zipped folder called QlikSenseData
. Extract all the files from this zipped folder, and save them on the hard drive at the desired location if you haven't done this for the previous recipes.
Once we have the files saved on the hard drive, go to the Qlik Sense app you have created to apply this recipe.
In order to run a windows command line, perform the following steps:
- Activate the legacy mode as described in Chapter 1, Getting Started with the Data.
- Open Qlik Sense
Data load editor
. - Write the following commands, assuming...