Chapter 2. Extract, Transform, and Load
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
