Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The whole script from page 415 is given below. When I remove the part after "group by", and run, I get a script error - Invalid Expression (Since no grouping of non-aggregated fields ???). When I include "group by", it says "Unknown statement - Group By" (illegal syntax ??? but the book uses it.). What is my mistake here ?
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;
damn... i now noticed that little semi-colon at the end of the load statement "
FROM
[..\3.QVD\Source\Flight Data.qvd]
(qvd) ;
". It should be removed.
After that, I got a new error - Field "%Aircraft Group ID" not found.
That is because the field name did not have proper spacing -
[%Aircraft Group
ID]
Put a space between Group and ID. Do this for all fields which are split into
multiple lines to be sure.
could you post the qvd?
EDIT: I found it, don't post
this (I copy your script) works with qvd find here
I bought the book and need flightdata.qvd file to practice...any help is highly appreciated...
perhaps somes field you split in different lines?
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)
//FROM
//[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;
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
[%Unique Carrier Code], [%Airline ID], [Unique Carrier], [%Unique Carrier Entity Code],
[%Region Code], [Carrier Code], [Carrier Name], [%Carrier Group ID],
[%Aircraft Group ID], [%Aircraft Type ID], [%Aircraft Configuration ID],
Period, Year, Quarter, [Month (#)], Month, [%Distance Group ID], [%Service Class ID], [%Datasource ID];
Store [Flight Data] into
Drop Table [Flight Data];
damn... i now noticed that little semi-colon at the end of the load statement "
FROM
[..\3.QVD\Source\Flight Data.qvd]
(qvd) ;
". It should be removed.
After that, I got a new error - Field "%Aircraft Group ID" not found.
That is because the field name did not have proper spacing -
[%Aircraft Group
ID]
Put a space between Group and ID. Do this for all fields which are split into
multiple lines to be sure.