Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Loading XML files to PostgreSQL database using Talend

Hi
We had of XML files that we loaded into our database, but each file only has 1 row in the table, where as each file has several rows. I believe this is because it is only recording the first entry for a node, and not all of the remaining entries. In the code example below, you will see that for Invoice items, there is 2 items in the code, but Talend is only picking up the first item, before being loaded into the database. Is there a way that the other items in the node that belong to the same tag can be imported into the database?
Thanks,
Killian
-<InvoiceItems>
 -<Item>
  <Description>ABC</Description>
  <Type>X-Ray</Type>
  <AmountExVAT>35.00</AmountExVAT>
  <InvoiceNumber/>
  <Date>2007-04-15</Date>
 </Item>
 -<Item>
  <Description>XYZ</Description>
  <Type>Medication</Type>
  <AmountExVAT>65.00</AmountExVAT>
  <InvoiceNumber/>
  <Date>2007-04-15</Date>
 </Item>
</InvoiceItems>
Labels (3)
1 Reply
Anonymous
Not applicable

Hi,
Could you please check a component TalendHelpCenter:tFileInputMSXML which reads and outputs multiple schema within an XML structured file?
Best regards
Sabrina