Originally posted by: venc1

Hi
I am new to WTX and trying to do group records based on key and then summarize all common records in one record

My input:
DeptNO Name amount
111 TOM 100.00
111 TOM 50.00
112 BOB 200.00

Output should be

111 TOM 150.00
112 BOB 50.00

Please advice
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: KiranMulpuru

First get all teh unique records
UNIQUE(Rec)
Next card you can pass these unique records and do the EXTRACT(each record) & do the SUM(amount) field
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

another way of doing it :
1)sort ip
2)use ctrl brk on key field
3)read each record set (combination of grouped records) at a time in a fmap
4)use sum to get the reqd result.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: NancyR

There is an example of that in a reply to the "Group the record and then summarize" post on this forum.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender