topic Re: HL7 Output Generation in Talend Studio

HL7 Output Generation

Anonymous — Tue, 24 Jun 2014 10:50:09 GMT

HI
Instead Of Fixed Flow input ,Can we Generate HL7 File from the values from Database.Please explain me the flow to generate HL7 from Database Values

Re: HL7 Output Generation

Anonymous — Wed, 25 Jun 2014 09:30:19 GMT

Hi,
What's your input source? You can also generate a HL7 Message with values in mysql
tmysqlinput -row(main)-->tmap -->thl7output. Could you please give us more info about your job requirement?
Best regards
Sabrina

Re: HL7 Output Generation

Anonymous — Thu, 09 Mar 2017 10:01:02 GMT

Hi Sabrina,

I want to generate HL7 message for all the records in my database. I could able to generate message for one record. But, for multiple records also, it is generating only one message. I attached my job screenshot. Please help me on this.

Re: HL7 Output Generation

vapukov — Thu, 09 Mar 2017 10:16:52 GMT

if You have success with single record, just use tFlowToIterate for convert Your database input flow into set of single records.
Input -> tFlowToIterate -> feature steps for single record

Re: HL7 Output Generation

Anonymous — Thu, 09 Mar 2017 10:30:20 GMT

Thank you vapukov for your reply. Even I tried that one. But iterate row should connect to which segment?

Re: HL7 Output Generation

vapukov — Thu, 09 Mar 2017 11:06:22 GMT

I of course do not know full logic of Job,
but You can play around:

if number of columns not big, insert it after tMap, from tMap Iterate connection to tFixedFlowInput which convert globalVariables back to flow
if number of columns big, it possible to make 2-step - select all ID only, then Iterate for each ID request all other columns by ID filter, than tMap and all other steps

Re: HL7 Output Generation

Anonymous — Thu, 09 Mar 2017 11:17:13 GMT

W ith this approach, only one file is generating for the last record.

Here is the screenshot:

Re: HL7 Output Generation

Anonymous — Fri, 10 Mar 2017 04:59:37 GMT

Can anyone please upload a sample job that generates HL7 messages for database records?
Thanks in advance!

Re: HL7 Output Generation

vapukov — Fri, 10 Mar 2017 08:19:49 GMT

With this approach, only one file is generating for the last record.

It is because - You are not manage file name per iteration. And with each iteration (till the last) - Your Job overwrite file
When You use iterations, You must manage file name, for example:

Re: HL7 Output Generation

Anonymous — Fri, 10 Mar 2017 09:21:57 GMT

Hi vapukov,

I tried that way only. But it is generating only one file. Could you please attach your working sample job?