Databases Reference
In-Depth Information
The structure and contents of the file are described as follows:
• It has a 4-line header, with information about the report above the actual
field names.
• Columns in the data area are delimited with tabs.
• Column labels are placed in the fifth line.
• After the column heading there is a "garbage" line intended to be a
visual separator.
• The report shows daily data with a weekly subtotal.
• The report shows ten weeks of data, with five of them on the left and the
other five placed on the right.
• Records with no specified date correspond to the same date as the
previous record.
We have taken the preceding file as an example since it represents a very common
way of pulling data out of certain particular systems. Even in popular ERP systems,
such as SAP, reports can be generated in this manner. Of course, there may be ways
to circumvent the unstructured report and go right to the source table, but in some
cases access is a bit restricted.
So, let's start cleaning up this mess.
Working with the Transformation Step wizard
We will load this file into a new QVW file, so let's begin by creating a new QlikView
document and saving it as
Production Planning.qvw
. This new file will be saved
inside the
Airline Operations\Side Examples\Chapter 9
folder. After saving
the file, make sure the
Production Planning - Legacy.txt
file is also at the
same location.
Next, open the Script Editor (
Ctrl
+
E
) and bring up the
File Wizard
by clicking on the
Table Files…
button.
