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:
NTE|1|Interpretive Data|Fasting reference:
NTE|2|Interpretive Data| Pre-Diabetes 100-125
NTE|3|Interpretive Data| Diabetes >125
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 ?