Databases Reference
In-Depth Information
Notice there is a prefix to the
Load
keyword with the names of the new fields. After
reloading the script, we will have a table with three fields (
Department
,
Month
, and
Sales
) ready to be used in a QlikView data model.
A solo exercise
We've covered the process of loading a Crosstable into QlikView, and now it's your
time to put it into practice. We've prepared a table file for you to load into QlikView.
The filename is
Employment Statistics - CrossTable.qvd
and it is located inside
the same
Airline Operations\Side Examples\Chapter 9
folder. It contains
Airline Employment Data (number of total employees), which the same we used
in the previous chapter, but with a Crosstable format.
The challenge for you consists of:
• Identifying the Qualifier fields
• Identifying the name of the Attribute field
• Generating the corresponding Load statement
• Determining how the transformed table can be loaded into the Airline
Operations data model
Good luck!
Expanding a hierarchy
A hierarchy table is a common format to store information in a parent-child structure.
The hierarchical nature of the table allows one value to be related to one or more
values across the table, as a parent or as a child. In fact, one value can be related
to one or more other values as a child and to one or more other different values
as a parent.
The advantage of these tables is that they keep the information in a compact
format, and QlikView is able to handle them, and expand its relations with
a special function:
Hierarchy
.
In technical terms, the original table format is called
an
Adjacent Nodes
table, while the resulting table
is called an
Expanded Nodes
table.
