https://community.qlik.com/t5/Talend-Studio/Get-xml-from-DB-multiple-rows-then-using-tExtractXML-produce-1/m-p/2309856#M81041 <P>Hi All,<BR />I am trying to read xml from a db and dump the contents to csv or db. For example:<BR />my query is select top 10 xml from xml table.<BR />I want to generate 10 (or more) rows of data to csv.<BR />I have created:&nbsp;<BR />tjDBCInput --&lt;main&gt; -- tExtractXMLField -- &lt;main&gt; -- tFileOutputDelimited&nbsp;<BR />However I am finding that 10 rows will be generated by DB component and passed onto XML component. The XML is passed correctly, but only 1 row will be generated by the XML component and saved into File component. (expecting 10 rows and 10 rows)<BR />Can anyone please help? It's the same when I replaced file with tLogRow. (see screenshot below)<BR /><BR /><BR /><BR />In addition, if I get this work, I want to extract more repeating elements out from the XML data, and output to a relational database, any tips?<BR /><BR />Many Thanks,<BR />Anthony<BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFXL.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/128333iD9A9AE6EE25C2B0F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFXL.png" alt="0683p000009MFXL.png" /></span></P> Thu, 21 Jul 2016 07:14:43 GMT Anonymous 2016-07-21T07:14:43Z https://community.qlik.com/t5/Talend-Studio/Get-xml-from-DB-multiple-rows-then-using-tExtractXML-produce-1/m-p/2309856#M81041 <P>Hi All,<BR />I am trying to read xml from a db and dump the contents to csv or db. For example:<BR />my query is select top 10 xml from xml table.<BR />I want to generate 10 (or more) rows of data to csv.<BR />I have created:&nbsp;<BR />tjDBCInput --&lt;main&gt; -- tExtractXMLField -- &lt;main&gt; -- tFileOutputDelimited&nbsp;<BR />However I am finding that 10 rows will be generated by DB component and passed onto XML component. The XML is passed correctly, but only 1 row will be generated by the XML component and saved into File component. (expecting 10 rows and 10 rows)<BR />Can anyone please help? It's the same when I replaced file with tLogRow. (see screenshot below)<BR /><BR /><BR /><BR />In addition, if I get this work, I want to extract more repeating elements out from the XML data, and output to a relational database, any tips?<BR /><BR />Many Thanks,<BR />Anthony<BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFXL.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/128333iD9A9AE6EE25C2B0F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFXL.png" alt="0683p000009MFXL.png" /></span></P> Thu, 21 Jul 2016 07:14:43 GMT https://community.qlik.com/t5/Talend-Studio/Get-xml-from-DB-multiple-rows-then-using-tExtractXML-produce-1/m-p/2309856#M81041 Anonymous 2016-07-21T07:14:43Z https://community.qlik.com/t5/Talend-Studio/Get-xml-from-DB-multiple-rows-then-using-tExtractXML-produce-1/m-p/2309857#M81042 okay i have figured out my self, the tExtractXMLElement component had a limit property which was set to 1. I have updated to an arbitrary 1000 and it worked. The question is though how to get it to a variable amount based on the previous rows retrieved. Fri, 22 Jul 2016 00:13:26 GMT https://community.qlik.com/t5/Talend-Studio/Get-xml-from-DB-multiple-rows-then-using-tExtractXML-produce-1/m-p/2309857#M81042 Anonymous 2016-07-22T00:13:26Z