topic Re: XML to Excel in Talend Studio

XML to Excel

Moe1 — Thu, 04 May 2023 07:12:42 GMT

Hello,

I have xml with the below format:

-<Document>

-<cltinf>

+<grphdr> (having many children)

+<pmtinf> (having many children and can be repeated with its children )

I want to extract them as columns which I am able to do that but the I want for each pmtinf occurrence to extract it as a new row, how to achieve this?

Re: XML to Excel

Anonymous — Thu, 04 May 2023 07:40:03 GMT

Hello

Can you show an example to explain your requirement? what you are getting now? what are your expected output?

Regards

Shong

Re: XML to Excel

Moe1 — Thu, 04 May 2023 08:23:00 GMT

Yeah sure, let assume the below schema:

<ch1>

<ch2>

.......

</grohdr>

<pch1>

<pch2>

<pch3>

.......

</pmtinf>

<pmtinf> (another occurrence of pmtinf; might be more than 2 occurrences)

<pch1>

<pch2>

<pch3>

.......

</pmtinf>

I want the excel columns/row as follows:

Columns: grphdr, ch1, ch2, subch2, pmtinf, pch1, pch2, pch3, subpch3.

Rows: 2 rows, 1st row has values of grphdr and 1st pmtinf occurrence with its children. 2nd row has the values of grphdr and 2nd pmtinf occurrence with its children.

Hope this clarifies!

Re: XML to Excel

Moe1 — Thu, 04 May 2023 11:44:53 GMT

mentioned below is my example.

Re: XML to Excel

Anonymous — Tue, 09 May 2023 03:53:42 GMT

@mohamad taha, the tFileInputXML and tExtractXMLFields component don't support extracting data from different loop elements at a time. As a workaround, use different tExtractXMLFields components to extract data from each loop element, then merge all columns from the two outputs, please refer to this topic.

Regards

Shong