Topic
  • 1 reply
  • Latest Post - ‏2019-03-29T11:47:14Z by PaulBrett
ashish7
ashish7
1 Post

Pinned topic Beginner WTX

‏2019-03-27T19:20:43Z | message oru

@PaulBrett

 

I am beginner and just started working on WTX last week .I am given ORU HL7 message and need to load into the table.

Below is sample:

MSH|
PID|PI.1|PID.2|PID.3
PV1|
OBR|
OBX|1|AA|TESTNAME^Value^code^range
OBX|2|AA|TESTNAME^Value^code^range
OBX|3|AA|TESTNAME^Value^code^range
NTE|1|Interpretive Data|Fasting reference:
NTE|2|Interpretive Data| Pre-Diabetes 100-125
NTE|3|Interpretive Data| Diabetes >125
OBX|4|AA|TESTNAME^Value^code^range
OBX|5|AA|TESTNAME^Value^code^range
OBX|6|AA|TESTNAME^Value^code^range
NTE|4|Interpretive Data| end of message

I want each OBX segment to become single output row  with extracted columns and also first column should be MRN from PID.3 and

 Also concatenate NTE segment fields to be converted into single row.

 

Can you please help with the logic ?

Thank you,

Ashish

  • PaulBrett
    PaulBrett
    326 Posts

    Re: Beginner WTX

    ‏2019-03-29T11:47:14Z  

    It is quite difficult to give any sort of meaningful/helpful advice, if you do not provide your input Typetree structure.

    Thank you.

    Paul

    Follow me on Twitter