Invalid Expression error

[samir_bihari]

Hi Experts ,

I am trying to load data from a table and using group by function but while executing getting invalid expression error. Below is the code snippet :

LOAD [Item SKU],

     [Item Status],

     Brand,

     Month,

     Model,

     Quarter,

     Year,

     Division,

     Sum([Sales Quantity]) as [Sales Quantity]

FROM

(qvd) Group By Key ;

The flat file contains many fields (Key is one of the field) but i want only the above mentioned field's data to be loaded grouped by Key .

Can anybody help here how to overcome this issue .

[prma7799]

Please share some sample data...

[tresesco]

Try like:

T1:

LOAD

     Key,

      [Item SKU],

     [Item Status],

     Brand,

     Month,

     Model,

     Quarter,

     Year,

     Division

FROM

(qvd) ;

Join

LOAD   

     Key, 

     Sum([Sales Quantity]) as [Sales Quantity]

FROM

(qvd) Group By Key ;