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.