CONCAT on OBX.5

Clovertech Forums Read Only Archives Cloverleaf Cloverleaf CONCAT on OBX.5

  • Creator
    Topic
  • #52633
    GEE MALONEY
    Participant

      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

    Viewing 0 reply threads
    • Author
      Replies
      • #74925
        Jim Kosloskey
        Participant

          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.

      Viewing 0 reply threads
      • The forum ‘Cloverleaf’ is closed to new topics and replies.