topic how can import and map multiple table from single XML in Talend Studio

how can import and map multiple table from single XML

Anonymous — Mon, 06 Aug 2018 10:24:31 GMT

Hello everyone,

i am start working on XML metadata, i have an issue to import multilevel XML into tables,

do i need to process one table at a time or any other options are available for XML.

i have attached sample schema of XML

Thanks in advanced

Re: how can import and map multiple table from single XML

David_Beaty — Mon, 06 Aug 2018 11:24:21 GMT

Hi,

If you are processing an XML document with multiple sets of repeating sections - at different levels within the document, you'll need to process it at each level separately.

Thanks

David

Re: how can import and map multiple table from single XML

jlolling — Tue, 20 Dec 2022 17:10:58 GMT

It is possible. I would use the tExtractXMLField.

Here a real life use case in which on every level we iterate and extract the next level as Document and hand over to the the next tExtractXMLField and so on....

Re: how can import and map multiple table from single XML

jlolling — Tue, 20 Dec 2022 17:12:26 GMT

Parsing the whole document within one job is sometimes essential to write in the database in one transaction.