Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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????
Since you are using sum() function, you must have group by clause.
Regards,
Kiran Rokkam
still giving the same error..
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