The power of any application lies in its data structure. QlikView can design very useful and functional data models. QlikView can extract data from disparate data sources and associate them to present a single version of the truth. The power of QlikView's ETL (extract, transform, and load) functionality can help organizations in transforming data.
In this chapter, you will learn how to extract data from different sources and transform them to design a data model. This data model will be used in later chapters to create dashboards. This chapter will help you in mastering ETL scripting in QlikView.
In this chapter, we shall learn about:
Scripting essentials
Building data models by loading data from relational data sources, Excel, and text files
Creating calculated fields in the tables
Different techniques to resolve synthetic keys
Resolving circular references
Loading Inline tables
Resident load
Including files
Using If statements