Originally posted by: SystemAdmin

Dev: Win XP sp2
Runtime: Sun Solaris 10
WTx: v8.1
Hi all,

I need to take a file, which has been sorted, and create a single record. The record is the sum of the amount where ID, Date, and Type match. What is the best/easiest way to handle this? Can this be done in the Type Tree?

Record Layout:
ID
Date-YYYYMM
Amount
Type (C or P)

Data:
111000316 199511 0006400 C
111000316 199511 0006400 C
111000316 199511 0006000 P
111000316 199511 0013400 P
192001347 200612 0016300 C
192001347 200703 0016300 C
192001347 200703 0014200 C
192001347 200703 0006300 C
192001347 200612 0015350 P
192001347 200612 0016355 P
192001347 200702 0002355 P
192001347 200702 0056325 P

Any help is appreciated.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: NancyR

You can do this with Control Break logic. See chapter 10 of the attached Design Studio Tutorial from the WTX 8.0 Online Library.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Thank you. This is what I was needing. When I searched the WTx help content, there was no references for Control Breaks. However, I knew there was something out there for this topic.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: jvanboga

Historically the PDFs will provide a very good starting place for questions like this. They are not always great for advanced questions but very solid on fundamentals.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender