Databases Reference
In-Depth Information
6. Rename the fields by clicking on the column headers and replacing the text
as follows:
Original name
New name
AC_TYPEID
%Aircraft Type ID
AC_GROUP
%Aircraft Group Type
SSD_NAME
Aircraft Name
MANUFACTURER
Aircraft Manufacturer
LONG_NAME
Aircraft Name Full
SHORT_NAME
Aircraft Name Abbreviated
BEGIN_DATE
Aircraft Begin Date
END_DATE
Aircraft End Date
7.
Complete the
Table File Wizard
window
by clicking on
Finish
.
8.
Replace the
Directory;
text with
[Aircraft Types]:
, this will assign that
name to the table.
The resulting code should look as follows:
[Aircraft Types]:
LOAD AC_TYPEID as [%Aircraft Type ID],
AC_GROUP as [%Aircraft Group Type],
SSD_NAME as [Aircraft Name],
MANUFACTURER as [Aircraft Manufacturer],
LONG_NAME as [Aircraft Name Full],
SHORT_NAME as [Aircraft Name Abbreviated],
BEGIN_DATE as [Aircraft Begin Date],
END_DATE as [Aircraft End Date]
FROM
[..\Data Files\CSVs\Aircraft_Base_File.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
Note how the source filename and path are specified in a relative manner, that is,
the location of the source file relative to the QlikView document. This happens
because we enabled the
Relative Paths
checkbox. Had we disabled the checkbox,
the full path and file name would have been used. For example, using relative paths
is convenient when your document will be moved around from a development to a
production environment.
Take a minute to review the rest of the script and see if your script matches.
