How to create XML

[Anonymous]

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.

[vboppudi]

Hi,

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

Regards,

[Anonymous]

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

[Anonymous]

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

[vboppudi]

You can post screen shot.

Regards,

[Anonymous]

InputOutput should be like