Databases Reference
In-Depth Information
9.
In the end, the
aggregation
script will look like this:
Flights:
LOAD
[%Airline ID],
[%Carrier Group ID],
[%Unique Carrier Code],
[%Unique Carrier Entity Code],
[%Region Code],
[%Aircraft Group ID],
[%Aircraft Type ID],
[%Aircraft Configuration ID],
[%Distance Group ID],
[%Service Class ID],
[%Datasource ID],
[Unique Carrier],
[Carrier Code],
[Carrier Name],
Year,
Period,
Quarter,
[Month (#)],
Month,
Sum([# Departures Scheduled]) as [# Departures Scheduled],
Sum([# Departures Performed]) as [# Departures Performed],
Sum([# Payload]) as [# Payload],
Sum([# Available Seats]) as [# Available Seats],
Sum([# Transported Passengers]) as [# Transported
Passengers],
Sum([# Transported Freight]) as [# Transported Freight],
Sum([# Transported Mail]) as [# Transported Mail],
Sum([# Ramp-To-Ramp Time]) as [# Ramp-To-Ramp Time],
Sum([# Air Time]) as [# Air Time]
FROM
[..\3.QVD\Source\Flight Data.qvd]
(qvd)
Group By
[%Airline ID], [%Carrier Group ID], [%Unique Carrier Code],
[%Unique Carrier Entity Code], [%Region Code], [%Aircraft Group
ID],
[%Aircraft Type ID], [%Aircraft Configuration ID], [%Distance
Group ID],
[%Service Class ID], [%Datasource ID], [Unique Carrier], [Carrier
Code],
[Carrier Name], Year, Period, Quarter, [Month (#)], Month;
10. Next, we will just save the changes and reload the script.
