Originally posted by: snutakki

Hai,

I have a scenario where the input file has multiple
DEL Records and the output file has 513 (one occurance) and 514 records (multiple)

I need to map 1st-5 occurances of DEL to element "X" in 513 record which
can repeat upto 5 times.

then from occurance 6-13 need to map to element "X" in 514 record(8 occurances of DEL are mapped to 8 occurances of "X")

similarly occurance 14-21 go to the next 514 record.

and so on upto "S" times

can anyone suggest a easy way to do accomplish this logic.

thanks,
cai
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: Margo

Hi -- I believe you can do this in your type tree for the output. Create an ouput containing the 513 followed by the 514. Then set the field in the 513 record to occur 0:5 times, and the 513 record itself only once. Then, set your 514 field for the record to be 0:5 (no more than five per instance, and the 514 record itself to (s), allowing the input to be consumed. You may want to look up break logic in the documentation.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender