We have seen four different scenarios in which the source table is not suitable for a QlikView data model, and we have shown the tools QlikView provides to deal with those formats. We have learned how to use the Transformation Wizard to remove garbage from input tables, fill missing cells, and unwrap table files.

We also learned what a Crosstable is, why it's not fit for the QlikView data model, and how to transform it into a traditional table. We saw how to deal with hierarchical tables and identify parent and child nodes.

Finally, we learned what a generic table is and how to take advantage of QlikView's ability to transform its structure.

In Chapter 13, Advanced Data Transformation, we will look at more advanced techniques for transforming source data for use in different data model designs.