CONCAT on OBX.5

[GEE MALONEY]

Sorry to bother everyone again with a simple question on how to get all the OBX.5 values to CONCAT into a single OBX segment and single OBX.5 value but I have been unsuccessful thus far.  🙁

Here is my incoming result information:

1(0).1(0).1(0).OBX(0)  :  >|1|TX|RESULT^Culture Result^PT-ANALYT|1|No Enteric Pathogens Isolated (Testing included Salmonella, Shigella,|||0|results||P|||201108031323|MAIN^ Main Laboratory||MICSTL< 1(0).1(0).1(1).OBX(0)  :  >|2|TX|RESULT^Culture Result^PT-ANALYT|2|Campylobacter and Escherichia coli O157)|||0|results||P|||201108031323|MAIN^Main Laboratory||MICSTL< 1(0).1(0).1(2).OBX(0)  :  >|3|ST|RESULT^Culture Result^PT-ANALYT|3||||0|results||P|||201108031323|MAIN^Main Laboratory||MICSTL

Here is what I have setup so far:

-Iterate on the OBX using Copy on all the fields I need in the OBX segment

-Copy @null on 1(0).1(0).1(0).OBX(%S1).#5(0)  << This prevents the output OBX.5 value from repeating

-Concat

Source:  ~1(0).1(0).1(0).OBX(0).#5(0).[0]

             1(0).1(0).1(0).OBX(%s1).#5(0).[0]

Destination:  1(0).1(0).1(0).OBX(0).#5(0).[0]

Output looks like this:

1(0).1(0).1(0).OBX(0)  :  >|1|TX|RESULT^Culture Result^PT-ANALYT||No Enteric Pathogens Isolated (Testing included Salmonella, Shigella,|||0|results||P|||201108031323< 1(0).1(0).1(1).OBX(0)  :  >|2|TX|RESULT^Culture Result|||||0|results||P|||201108031323< 1(0).1(0).1(2).OBX(0)  :  >|3|ST|RESULT^Culture Result|||||0|results||P|||201108031323< Thank you for your advice.   ginny

Topic

[Jim Kosloskey]

Ginny,

For one thing, I think you have your iteration counter in the wrong position in the address path of your Xlate Actions – it appears you have the repetition at the segment level but it is a group repetition based on the message display.

If you have that wrong, your basis for the ITERATE may be incorrect as well – so make sure that is correct. Remember if the basis is not right in the ITERATE nothing subordinate to the ITERATE will work correctly.

Also just for information purposes is there a BULKCOPY in your Xlate?

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Author]

Replies