I am making simple job like this:-
Ddataset--->aggrigator stage ------>Dataset
Input columns are :-
Columns Data types
HUB Varchar
CIRCLE Varchar
DATE Date
AMOUNT Decimal (10,4)
I want sum of amount column basced on
HUB,CIRCLE and DATE
I have selected these in aggrgator stage:-
Grouping keys:-
HUB, CIRCLE and Date
Aggrigation
aggrigation Type =Calculation
Col. For cal=AMOUNT
Sum o/p col=SUM_AMOUNT
Default to decimal o/p=8,2
and partitioning is hash on key columns
But in o/p i m getting null record in SUM_AMOUNT column
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)
Please help me to resolve this problem
Thanks in advance