0
380
Question Michael ochieng · Jun 17, 2019

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 

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

Comments

Sean Connelly · Jun 17, 2019

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|
0
Michael ochieng  Jun 17, 2019 to Sean Connelly

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

0