Error

[mario-sarkis]

LOAD

[RMID] ,

Balance,

max(Date) as MaxPeriodDate

Resident Input

group by[RMID],PeriodMonth;

Drop table Input ;

Hey i am writing this in the Script it told me an Error:

"Invalid Expression"

what is wrong with it ?

Help please

[#2]

Hi ,

try this

LOAD

[RMID] ,

Balance,

max(Date) as MaxPeriodDate

Resident Input

group by[RMID],Balance;

Drop table Input ;

in  group by we have to Qualify the all remaining fields which are are there in the Table 

[antoniotiman]

Hi Mario,

Try

Inner Join Load

[RMID],

Max(Date) as MaxPeriodDate

Resident Temp

Group By [RMID];

Besides, are You sure Date field is date Type ?