How to create XML

Six Stars

How to create XML

Hi,

I have to create a XML. I have columns, id, fromCtry, toCtry, Rate. I have to create a xml tag containing fromCtry, toCtry, Rate and those are group by id. I need output as id(as coming from input), xmlString, so in another job, I can join based on id.

In output id I needed as a separate column.

How I can achieve it?

Much appreciated for help.

Nine Stars

Re: How to create XML

Hi,

If possible please provide source and target XML output format and data.

Regards,

Veeru Boppudi
Six Stars

Re: How to create XML

I am trying to paste but it is getting removed by moderator.
Six Stars

Re: How to create XML

Here is my input,
id|Frm|to|rate
754|Dallas|London|58.7171
755|Dallas|Europe|0.30727
755|Dallas|brazil|0.30723
756|Dallas|Europe|0.40727
756|Dallas|brazil|0.68727
757|Europe|brazil|3.30769
Nine Stars

Re: How to create XML

You can post screen shot.

 

Regards,

Veeru Boppudi
Six Stars

Re: How to create XML

Input.JPGInputOutput.JPGOutput should be like