Script

[rajni_batra]

CustomerLedgerEntry:

LOAD

          *,

          If(sum([Remaining Amount])>1000000 ,sum([Remaining Amount]),0) as Group1

Resident CustomerLederEntry;

DROP Table CustomerLederEntry;

during Reload it reflects invalid Expresion .. whats wrong????

[#2]

Since you are using sum() function, you must have group by clause.

Regards,

Kiran Rokkam

[rajni_batra]

still giving the same error..

[#4]

remove * after reload and substitute only those fields respect to which you want to take group by as:

load

[Remaining Amount],

If(sum([Remaining Amount])>1000000 ,sum([Remaining Amount]),0) as Group1

Resident CustomerLederEntry group by [Remaining Amount] ;

DROP Table CustomerLederEntry;

regards

vijit