Databases Reference
In-Depth Information
And finally, we have the bottom pane, which at the same time is divided into several
tabs. Let's go through each of them briefly:
•
Script
: This tab will give a preview of what the wizard will create based on
our selections from the panes above.
° To the right, we have additional options to specify how we want the
script to be generated (
Column
,
Row
, or
Structured
). We can also
add a
Preceding Load
, which lists the resulting fields individually
and makes them available for QlikView-side operations.
° We also have an
Add…
button which basically allows the creation of
several
Select
statements involving several tables at the same time,
without needing to click on
OK
and then return to the
Create Select
Statement
window for each one.
•
Table
: This tab is used to view general information about the selected
database table.
•
Columns
: This tab will provide specific information about the properties of
the fields that make up the table.
•
Preview
: This tab will show a preview of the table, consisting of the first
few rows.
•
Blobs
: This tab provides the ability to bundle objects contained in a
Binary
Large Object (Blob)
field into the QlikView application. This feature is
only supported when using an ODBC connection (OLE DB is not supported
for this).
Adding the airport tables
Even though the Access database contains all of the dimension tables used in
the Airline Operations data model and more, we will only extract the tables
corresponding to the origin and destination airports and incorporate them into
our application.
Using the
Create Select Statement
wizard described earlier, create the
Select
statement to extract the
Origin Airports
table with both the
%Origin Airport
ID
and
Origin Airport
fields. Make sure to create a script in the form of
Column
with each
field name listed in
Preceding Load
for us to manipulate it further, if needed.