Hello,
I am having a few issues importing a HL7 file into my database. I am using the tHL7Input component and I have defined the schema for each segment that I want want to import. I am able to view each segment using tLogRow, but I am not sure how to import the file into my table with the needed identifiers. I would like to combine data from the message header with the results so that I can tie everything together, but each segment has a different schema. Is it possible to combine the the message header with different segments of the message? I tried using tMap but it will only let me map 1 segment or row to it.
Hopefully that all makes sense, basically I just need to find a way to combine one schema with another from the component. I have attached an image of what I have so far.
Any help would be much appreciated. Thanks.
I know this thread is very old but, if anyone stumbles upon it I wanted to add a solution.
Rather than appending each segment with a patient identifier from the MSH and PID segments. Anyone trying to do what the original poster is trying to do would just need to create a new column or table in their database with a trigger to create a unique message identifier as that message is ingested. This way each row is linked back to the same unique ID along with any information you've extracted from each segment. This is basic database record key management and is exactly what relational databases are for.
