topic Re: Import XML file to SQL database in Talend Studio https://community.qlik.com/t5/Talend-Studio/Import-XML-file-to-SQL-database/m-p/2285932#M59554 In the tLogRow, is it printing as expected? After tlogrow you can connect to tdboutput component and chose the your db type. Wed, 08 Apr 2020 09:01:16 GMT manodwhb 2020-04-08T09:01:16Z Import XML file to SQL database https://community.qlik.com/t5/Talend-Studio/Import-XML-file-to-SQL-database/m-p/2285931#M59553 <P>I have an XML script and I want to insert those data into an SQL table.</P> <P>XML Script is attached.</P> <P>This is what I have tried so far.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Job" style="width: 440px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M929.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/131521i26A3D1237C25BD3E/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M929.png" alt="0683p000009M929.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">Job</SPAN></SPAN></P> <P>Actual Output:</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ActualOutput" style="width: 916px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9Db.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/135348iB5FC1C0CAD2161A9/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9Db.png" alt="0683p000009M9Db.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">ActualOutput</SPAN></SPAN></P> <P>Expected Output: I want those XML data to be displayed in a tabular Table, e.g:</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DummyData" style="width: 378px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9PC.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138407iE413DBFCE377CF44/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9PC.png" alt="0683p000009M9PC.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">DummyData</SPAN></SPAN></P> <P>I'm completely new to talend and don't know how to proceed.</P> <P>&nbsp;</P> Sat, 16 Nov 2024 02:45:25 GMT https://community.qlik.com/t5/Talend-Studio/Import-XML-file-to-SQL-database/m-p/2285931#M59553 Anonymous 2024-11-16T02:45:25Z Re: Import XML file to SQL database https://community.qlik.com/t5/Talend-Studio/Import-XML-file-to-SQL-database/m-p/2285932#M59554 In the tLogRow, is it printing as expected? After tlogrow you can connect to tdboutput component and chose the your db type. Wed, 08 Apr 2020 09:01:16 GMT https://community.qlik.com/t5/Talend-Studio/Import-XML-file-to-SQL-database/m-p/2285932#M59554 manodwhb 2020-04-08T09:01:16Z Re: Import XML file to SQL database https://community.qlik.com/t5/Talend-Studio/Import-XML-file-to-SQL-database/m-p/2285933#M59555 <P>tlogRow is not printing as expected.</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Output" style="width: 600px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9B1.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/150710i8EC647ED4E90B6F4/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9B1.png" alt="0683p000009M9B1.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">Output</SPAN></SPAN></P> <P>Output In tLogRow:</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tLogRowOutput" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M99t.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/141650i5374CC7E8308C00F/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M99t.png" alt="0683p000009M99t.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">tLogRowOutput</SPAN></SPAN></P> Wed, 08 Apr 2020 09:43:37 GMT https://community.qlik.com/t5/Talend-Studio/Import-XML-file-to-SQL-database/m-p/2285933#M59555 Anonymous 2020-04-08T09:43:37Z Re: Import XML file to SQL database https://community.qlik.com/t5/Talend-Studio/Import-XML-file-to-SQL-database/m-p/2285934#M59556 <P><A href="https://community.qlik.com/s/profile/0053p000007LR1PAAW">@PraKan1605</A>, you might have not configured tXmlMap as you need the output way.</P> Thu, 16 Apr 2020 14:09:29 GMT https://community.qlik.com/t5/Talend-Studio/Import-XML-file-to-SQL-database/m-p/2285934#M59556 manodwhb 2020-04-16T14:09:29Z