In this chapter, we will discuss the creation of optimized and well-structured scripts for a Qlik Sense application. We are going to cover the following topics:
For Each
loop to load data from multiple filesConcat
function to store multiple field values in a single cellWhat is a script in Qlik Sense? In lay man's language, a script instructs the Qlik Sense engine on how to extract the data from the data source and what to do with it.
It forms an essential component of the ETL process. Hence, it is important to have a well-structured script in order to load the data efficiently. A good understanding of how to optimize an ETL process, leads to a better data model. A good data model is one of the core components along side well written expressions to realize a good user interface performance.