Originally posted by: SystemAdmin

I would truly appreciate it if someone can help me figure out this issue I am having. I am trying to output the input data that is in a looping structure to a multiple output records.

For example
Input:
20|1|EL|ACCOUNT|*LS:96.73000000::A:^LS:144.38000000::A:*||20080520|20080722
25|1|C|EU|ENC001|1209.17000000|0.09598900|KH|12597.00000000|ABC
25|2|C|EU|ENC001|1804.80000000|0.13879900|KH|13003.00000000|ABC

Output:
I only have one output for each record. The 20 records repeat and the 25 data is on a different line. I need the first line to have the 96.73 with qualifier LS and the second record to have 144.38 with qualifier LS.

Example output: You will noticed, these two lines matches the input but the only charge that came out was the 144.38. Thanks.
~0.096~KH~12597~~144.38~2~05/20/2008~07/22/2008~~~~~~~EL
~0.1388~KH~13003~~144.38~2~05/20/2008~07/22/2008~~~~~~~EL

I know I have to create a functional map, even with that I am not getting the output to be correct. It is only capturing the 144.38. Any help would truly be appreciated. Thanks.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: paul.brett

I would be helpful for you to post your input typetree.

Paul.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: janhess

I would guess that the output only occurs once, thus the last value is placed in it.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

I was wondering if I set up a group for my output and set a delimiter, would this work. I could use the Choose and extract function as well? I am not sure what my input type tree would do to help with this solution. If you can let me know. I would be glad to upload it. Thank you so much for your help. I truly appreciate it.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender