https://community.qlik.com/t5/Talend-Studio/How-to-create-XML/m-p/2307880#M79272 <P>Hi,</P><P>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&nbsp;job, I can join based on id.</P><P>In output id I needed as a separate column.</P><P>How I can achieve it?</P><P>Much appreciated for help.</P> Thu, 21 Jun 2018 20:50:54 GMT Anonymous 2018-06-21T20:50:54Z https://community.qlik.com/t5/Talend-Studio/How-to-create-XML/m-p/2307880#M79272 <P>Hi,</P><P>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&nbsp;job, I can join based on id.</P><P>In output id I needed as a separate column.</P><P>How I can achieve it?</P><P>Much appreciated for help.</P> Thu, 21 Jun 2018 20:50:54 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-XML/m-p/2307880#M79272 Anonymous 2018-06-21T20:50:54Z https://community.qlik.com/t5/Talend-Studio/How-to-create-XML/m-p/2307881#M79273 <P>Hi,</P><P>If possible please provide source and target XML output format and data.</P><P>Regards,</P> Thu, 21 Jun 2018 21:30:55 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-XML/m-p/2307881#M79273 vboppudi 2018-06-21T21:30:55Z https://community.qlik.com/t5/Talend-Studio/How-to-create-XML/m-p/2307882#M79274 I am trying to paste but it is getting removed by moderator. Thu, 21 Jun 2018 22:04:02 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-XML/m-p/2307882#M79274 Anonymous 2018-06-21T22:04:02Z https://community.qlik.com/t5/Talend-Studio/How-to-create-XML/m-p/2307883#M79275 Here is my input,<BR />id|Frm|to|rate<BR />754|Dallas|London|58.7171<BR />755|Dallas|Europe|0.30727<BR />755|Dallas|brazil|0.30723<BR />756|Dallas|Europe|0.40727<BR />756|Dallas|brazil|0.68727<BR />757|Europe|brazil|3.30769<BR /> Thu, 21 Jun 2018 22:17:40 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-XML/m-p/2307883#M79275 Anonymous 2018-06-21T22:17:40Z https://community.qlik.com/t5/Talend-Studio/How-to-create-XML/m-p/2307884#M79276 <P>You can post screen shot.</P><P>&nbsp;</P><P>Regards,</P> Thu, 21 Jun 2018 22:18:03 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-XML/m-p/2307884#M79276 vboppudi 2018-06-21T22:18:03Z https://community.qlik.com/t5/Talend-Studio/How-to-create-XML/m-p/2307885#M79277 <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Input" style="width: 311px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Ly51.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/145057i69F0E7424A318538/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Ly51.jpg" alt="0683p000009Ly51.jpg" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">Input</SPAN></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Output should be like" style="width: 468px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Ly5B.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154663i78F4B869940E3482/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Ly5B.jpg" alt="0683p000009Ly5B.jpg" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">Output should be like</SPAN></SPAN></P> Thu, 21 Jun 2018 23:02:22 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-XML/m-p/2307885#M79277 Anonymous 2018-06-21T23:02:22Z