Error : Invelid Exrpression

[Ankit5]

Details:

Load 

Max_Rec,

[Refrence Number],

[Transaction Date],

concat([Add on Short], ',') as [Add on Detalis]

From D:\Ankit\MotorAddon.qvd

Group by  [Refrence Number];

above script is executed at time recived error msg Invelid Expression. can any one suggest where i am wrong.

thanks 

[maxgro · Accepted solution]

try this

Load
Max_Rec,
[Refrence Number],
[Transaction Date],
concat([Add on Short], ',') as [Add on Detalis]
From D:\Ankit\MotorAddon.qvd
Group by
[Refrence Number], Max_Rec, [Transaction Date]

;

[Ankit5]

thanks @ Maxgro its working