Question
· Jun 17, 2019

merge and match

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 

Discussion (2)1
Log in or sign up to continue

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|