Databases Reference
In-Depth Information
The finished code should look like this:
[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);
LEFT JOIN ([Aircraft Types])
LOAD [Aircraft Group ID] as [%Aircraft Group Type],
[Aircraft Engine Type],
[Aircraft Number Of Engines]
FROM
[..\Data Files\CSVs\Aircraft_Group.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
DROP FIELD [%Aircraft Group Type] FROM [Aircraft Types];
CONCATENATE([Aircraft Types])
LOAD AC_TYPEID as [%Aircraft Type ID],
SubField(AC_GROUPNAME, ', ', 1) as [Aircraft Engine Type],
SubField(AC_GROUPNAME, ', ', 2) as [Aircraft Number Of
Engines],
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_2010_Update.csv]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
