Scenario: Retrieving information about patients and events from an HL7 file - 6.3

Talend Components Reference Guide

EnrichVersion
6.3
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

This scenario describes a four-component Job which retrieves information about patients and events from an HL7 file.

Configuring the editor of tHL7Input

  1. From the Palette, drop an tHL7Input and three tLogRow components onto the design workspace.

  2. Double-click tHL7Input in order to open its editor.

  3. In the File path field, click [Browse...] and browse the directory to select your HL7 file.

  4. In the File Setting area, type in your segment Start character and your segment End character.

  5. Under Segment(As Schema), in the Schema view area, select MSH.

  6. Drop the MSH-3(1)-1-1[IS] and MSH-7(1)-1-1[ST] segments from the Message View onto the Schema View, and change the User Column value to MSH_LABEL and MSH_DATE respectively.

  7. Under Segment(As Schema), in the Schema view area, select EVN.

  8. Drop the EVN-1(1)-1-1[ID] and EVN-2(1)-1-1[ST] segments from the Message View onto the Schema View, and change the User Column value to EVN_ID and EVN_DATE respectively.

  9. Under Segment(As Schema), in the Schema view area, select PID.

  10. Drag and drop the following segments from the Message View onto the Schema View: PID-1(1)-1-1[SI], PID-5(1)-1-1[ST], PID-5(1)-2-1[ST], PID-5(1)-3-1[ST], PID-5(1)-4-1[ST], PID-5(1)-5-1[ST], PID-7(1)-1-1[ST], PID-8(1)-1-1[IS], then change the User Column value to PID_ID, PID_FNAME, PID_LNAME, PID_STNUMBER, PID_STREET, PID_CITY, PID_BDAY, PID_GENDER.

    Note

    If available, click the Auto map! button, located at the bottom left of the interface, to carry out the mapping operation automatically.

  11. Click Ok to close the editor.

Configuring the output components

  1. Double-click tLogRow_1 to display its Basic settings view and define the component properties.

  2. Select Table (print values in cells of a table) mode to display the execution result.

  3. Do the same with tLogRow_2 and tLogRow_3.

Job Execution

  1. Link tHL7Input to the three tLogRow components, using MSH, EVN and PID links respectively.

  2. Save your Job and press F6 to execute it.

The console displays the three tLogRow tables, which return different types of information. The first one gives the message header label and its date. The second table shows the information about the patient. The third one displays the event ID and its date.