Databases Reference
In-Depth Information
We've successfully loaded a "dirty" file into QlikView by taking advantage of one of
its extraction capabilities. This capability broadens QlikView's ability to consolidate
data from disparate sources and empowers the QlikView developer in the data
model design process.
Other transformation tricks
Let's look at some other options the Transformation Step Wizard provides:
•
Column
: This tab allows us to copy data from one column, either in its
entirety or based on conditions, and place it into other columns. We can
also create new columns based on this copy.
•
Rotate
: This tab can be used to rotate an entire table to either side or by
transposing it.
•
Context
: This tab is only available when loading HTML files and can be
used to extract additional information about the cells, other than what is
actually visible (for example, URL links, tags, and so on).
We've uncovered one of the Transformation tools available in QlikView, and now
it's time to learn about other functions we can use when extracting data.
Loading a Crosstable
To be fair, the example we saw in the preceding section is possible but is actually
rare. A more common example of a source table that is unfit for QlikView is
the Crosstable.
In this section, we will describe what a Crosstable is for QlikView, why it's not
suitable for a data model, and how can we transform it into a traditional table
using QlikView's extraction engine.
A Crosstable example
Let's look at the following input table:
Department
Jan
Feb
Mar
Apr
May
Jun
A
160
336
545
152
437
1
B
476
276
560
57
343
476
C
251
591
555
195
341
399
D
96
423
277
564
590
130
