Multiple Input Cards to Single Out Card

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
Rajesekhar
Participant
Posts: 19
Joined: Fri May 14, 2010 3:54 pm

Multiple Input Cards to Single Out Card

Post by Rajesekhar »

Dear All,

I have two different application systems sending message with same format. Requirement is to append Application 2 input to Application 1 input at output.

Application 1:
<AddressDetails>
<Address>
<City>chicago</City>
<State>illinois</State>
<Country>US</Country>
</Address>
<Address>
<City>Seattle</City>
<State>Washington</State>
<Country>US</Country>
</Address>
</AddressDetails>

Application 2:
<AddressDetails>
<Address>
<City>indianapolis</City>
<State>indiana</State>
<Country>US</Country>
</Address>
</AddressDetails>

Output:
<AddressDetails>
<Address_From_application1>
<City>chicago</City>
<State>illinois</State>
<Country>US</Country>
</Address_From_application1>
<Address_From_application1>
<City>Seattle</City>
<State>Washington</State>
<Country>US</Country>
</Address_From_application1>
<Address_From_application2>
<City>indianapolis</City>
<State>indiana</State>
<Country>US</Country>
</Address_From_application2>
</AddressDetails>

I need to use two input cards for each application. but as output is only one type tree, I am wondering how to achieve this using WTX. How can we append two input messages.

Please let us know if anyone came across such situation. Thank you.
Rajesekhar Potteti
paul.brett
Participant
Posts: 3
Joined: Wed Aug 06, 2014 6:22 am
Location: Cambridgeshire

Post by paul.brett »

I have attached a complete solution for this issue, to a similar post on the developerWorks forum:

https://www.ibm.com/developerworks/comm ... 8dd9&ps=25
Paul Brett
IBM WebSphere Transformation Extender (WTX) Client Support
IBM Software Services, Support and Success
Industry Cloud Solutions
IBM UK
Post Reply