Databases Reference
In-Depth Information
We can start typing data into the cells, and after we are finished entering the content
of the table, we can click on
OK
.
Importing document data to the Inline table
It is possible to enter, within the Inline wizard, a list of values
contained in a field that is already stored in RAM. This is done via the
Import Document Data
wizard. To bring up this wizard, go to the
Tools
menu from the
Inline Data
wizard and select
Document Data…
.
The resulting script for our input table would be similar to the following:
LOAD * INLINE [
ID, Description
1, One
2, Two
3, Three
4, Four
5, Five
6, Six
7, Seven
8, Eight
9, Nine
10, Ten
];
The advantage of this approach is that you will not need to maintain a separate table
(whether on a database or a table file) when dealing with a small table of this sort.
Keep in mind that the values will be hardcoded in the script. Whenever you need to
change them, it can only be changed in the script.
Summary
We have covered the most basic extraction capabilities that QlikView provides. We
have also described the different data sources you can access from QlikView and
provided a few tips for dealing with input tables.
At the same time, the technical team at HighCloud Airlines has been able to assess
that QlikView can load data from disparate sources, and see the different options
they will have at their disposal with QlikView regarding data sources. They have
also been presented with one of the most important differentiators of the QlikView
software; that is, its ability to read and process data stored in disparate sources,
and combine them, associate them, link them, and store it all in one location (the
QlikView document), to enable a complete insight and analysis for QlikView users.
In the next chapter, we will learn how we can turn our extracted data into a proper
data model.
