Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a question about a expression. I have make a expression and when I click on the button reload then I get a error: invalid expression.
Can someone help me? What is wrong with the expression?
thanks in advance.
my expression is:
LOAD [%Airline ID],
[%Carrier Group ID],
[%Unique Carrier Code],
[%Unique Carrier Entity Code],
[%Region Code],
//[%Destination Airport Sequence ID],
// [%Destination Airport Market ID],
// [%Destination World Area Code],
[%Aircraft Group ID],
[%Aircraft Type ID],
[%Aircraft Configuration ID],
[%Distance Group ID],
[%Service Class ID],
[%Datasource ID],
Sum ( [# Departures Scheduled] ) as [# Departures Scheduled] ,
Sum ( [# Departures Performed]) as [# Departures Performed],
Sum ([# Payload] ) as [# Payload],
Distance,
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],
[Unique Carrier],
[Carrier Code],
[Carrier Name],
[Origin State Code],
Year,
Period,
Quarter,
[Month (#)],
Month
FROM
(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;
same question?
Hi maichel s
Your Error Show like this ????
Try it
In the ''group by", you missed fields Distance and [Origin State Code]
and mainly you check in the script function while loading the data.
Check with this
LOAD
[%Airline ID],
[%Carrier Group ID],
[%Unique Carrier Code],
[%Unique Carrier Entity Code],
[%Region Code],
//[%Destination Airport Sequence ID],
// [%Destination Airport Market ID],
// [%Destination World Area Code],
[%Aircraft Group ID],
[%Aircraft Type ID],
[%Aircraft Configuration ID],
[%Distance Group ID],
[%Service Class ID],
[%Datasource ID],
Sum ( [# Departures Scheduled] ) as [# Departures Scheduled] ,
Sum ( [# Departures Performed]) as [# Departures Performed],
Sum ([# Payload] ) as [# Payload],
Distance,
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],
[Unique Carrier],
[Carrier Code],
[Carrier Name],
[Origin State Code],
Year,
Period,
Quarter,
[Month (#)],
Month
FROM
(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;
hi
I think you are missing distance field in group by caluse.
Please check.
Regards
Sawmsie
Dear,
Run step by step with dimensions.
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],
Distance,
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],
[Unique Carrier],
[Carrier Code],
[Carrier Name],
[Origin State Code],
Year,
Period,
Quarter,
[Month (#)],
Month
FROM
(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],Distance,
[Unique Carrier],
[Carrier Code],
[Carrier Name],
[Origin State Code],
Year,
Period,
Quarter,
[Month (#)],
Month;
Regards
Vimlesh
Hi,
I think you're missing Distance in GROUP BY, it's not part of aggregation so it should be in the group by.
I will add that into group by and reload.