Originally posted by: ashish7

@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

Originally posted by: PaulBrett

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