https://community.qlik.com/t5/Talend-Studio/how-to-extract-data-from-xml-tags-which-have-same-tag-name-and/m-p/2270534#M48410 <P>Do you know how many roles elements you will have in your XML? If so you can get them using the following method.</P> <P>&nbsp;</P> <P>Your XPath loop will be.....</P> <PRE>"/root/root"</PRE> <P>You can get the first "roles" value using this....</P> <PRE>"roles[1]"</PRE> <P>....the second using this....</P> <PRE>"roles[2]" </PRE> <P>....etc, etc...</P> <P>&nbsp;</P> <P>You would then merge them together, maybe using a tMap</P> Mon, 25 Nov 2019 17:15:23 GMT Anonymous 2019-11-25T17:15:23Z https://community.qlik.com/t5/Talend-Studio/how-to-extract-data-from-xml-tags-which-have-same-tag-name-and/m-p/2270533#M48409 <P>Hi.!</P><P>&nbsp;</P><P>The input is&nbsp;</P><DIV>&lt;root&gt; &lt;root&gt; &lt;id&gt;1&lt;/id&gt; &lt;FN&gt;aa&lt;/FN&gt; &lt;roles&gt;bb&lt;/roles&gt; &lt;roles&gt;cc&lt;/roles&gt; &lt;roles&gt;dd&lt;/roles&gt; &lt;roles&gt;ee&lt;/roles&gt; &lt;/root&gt; &lt;/root&gt;</DIV><DIV>&nbsp;</DIV><DIV>but I need to get add the roles in the single column like this&nbsp;</DIV><DIV>id&nbsp; FN&nbsp; roles</DIV><DIV>1&nbsp; aa&nbsp; &nbsp;bb,cc,ee,dd</DIV><DIV>&nbsp;</DIV><DIV>Thanks in advance.!</DIV> Mon, 25 Nov 2019 13:32:03 GMT https://community.qlik.com/t5/Talend-Studio/how-to-extract-data-from-xml-tags-which-have-same-tag-name-and/m-p/2270533#M48409 McJingles 2019-11-25T13:32:03Z https://community.qlik.com/t5/Talend-Studio/how-to-extract-data-from-xml-tags-which-have-same-tag-name-and/m-p/2270534#M48410 <P>Do you know how many roles elements you will have in your XML? If so you can get them using the following method.</P> <P>&nbsp;</P> <P>Your XPath loop will be.....</P> <PRE>"/root/root"</PRE> <P>You can get the first "roles" value using this....</P> <PRE>"roles[1]"</PRE> <P>....the second using this....</P> <PRE>"roles[2]" </PRE> <P>....etc, etc...</P> <P>&nbsp;</P> <P>You would then merge them together, maybe using a tMap</P> Mon, 25 Nov 2019 17:15:23 GMT https://community.qlik.com/t5/Talend-Studio/how-to-extract-data-from-xml-tags-which-have-same-tag-name-and/m-p/2270534#M48410 Anonymous 2019-11-25T17:15:23Z https://community.qlik.com/t5/Talend-Studio/how-to-extract-data-from-xml-tags-which-have-same-tag-name-and/m-p/2270535#M48411 <P>Thanks,&nbsp;<A href="https://community.qlik.com/s/profile/005390000069RuGAAU">@rhall</A>&nbsp; It worked...</P> Tue, 26 Nov 2019 04:09:38 GMT https://community.qlik.com/t5/Talend-Studio/how-to-extract-data-from-xml-tags-which-have-same-tag-name-and/m-p/2270535#M48411 McJingles 2019-11-26T04:09:38Z