How to generate two XML files from a single HL7 file and insert both into two different columns as a single record?
- by Vivek Ratnaparkhi
I have Source Connector Type as 'File Reader' which is reading HL7 files and Destination Connector Type as 'Database Writer'.
My database table has two columns
Participant_Information
SPR_Information
I want to transform a single HL7 file into two XML files one for Participant_Information column and other for SPR_Information column and need to insert both as a single record into the database table.
I'm able to insert one XML at a time but not able to find the way to insert both the XMLs as a single record into the database table.
Any help is really greatly appreciated!