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