Creating a XML segment from Differnt XML segments

[anbu bose]

I want to convert below 'from' xml structure to 'to' xml structure.

From:

 

 

James

 

 

 

 

 

Bond

 

 

 

 

 

45

 

 

To:

 

 

James

Bond

45

 

 

I am using Tibco BW 5.13 version. Could youprovide your ideas to achive this structure.

 

Thanks

Bose

[Abhishek Singh 8]

Hi ,

Create a parser to parse the xml first , then create a iterative loop over a mapper to iterate over the ouput xml from parser , for each iteration get the value of the fieldfrom the output of the mapper and assign it to a process variable.

create a new mapper outside the loop and then use the values from the process variable to write it into a xml of desired format.