error in expression

[#1]

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;

[maxgro]

same question?

invalid expression; what is wrong?

[#3]

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;

[mightyqlikers]

hi

I think you are missing distance field in group by caluse.

Please check.

Regards

Sawmsie

[#5]

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

[Gabriel]

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.