This chapter covered the basics of QlikView scripting and data loads. You were able to load data from a relational database and flat files to get started on creating a data model. This chapter also covered the data transformations required to find a sales person, ProductLine grouping, and calculated fields in the tables. As more tables are loaded, synthetic and circular loops are produced. By learning to resolve synthetic keys and loops, you are on your way to producing an optimized data model.
In the next chapter, you will learn how to reduce the number of tables and joins in your data model by using mapping load and applymap functions. You will also learn about different kind of joins in QlikView.