HL7 Output Generation

HL7 Output Generation

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
Moderator

Re: HL7 Output Generation

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: HL7 Output Generation

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.
Twelve Stars

Re: HL7 Output Generation

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
-----------
Four Stars

Re: HL7 Output Generation

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

Re: HL7 Output Generation

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
-----------
Four Stars

Re: HL7 Output Generation

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

Here is the screenshot:



Four Stars

Re: HL7 Output Generation

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

Re: HL7 Output Generation

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:
-----------
Four Stars

Re: HL7 Output Generation

Hi vapukov,

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