merge and match

Ensemble

Hi guys 

i'm trying to create a DTL that allows me to merge several OBX  segments into one . eeverything in the segments is the same except the values in OBX 5 which id like to   all to be  merged together 

Answers

Hi Michael,

1. Copy the entire first source OBX to the first target OBX
2. Loop over the source OBX group
3. In the loop, if the loop key is greater than 1, append the source OBX 5 value to the first target OBX 5 with a preceding delimiter

It should look something like this...

If the source is...

OBX|1||||Alpha|
OBX|2||||Bravo|
OBX|3||||Charlie|


Then your target will output as...

OBX|1||||Alpha Bravo Charlie|

Sean thanks a lot let me try  and  ill post the results