from different XML nodes to array

solquest — Sat, 16 Nov 2024 00:24:35 GMT

Hey there.

I'm almost a newbie with Talend...I have an XML file and I have to put its different nodes in the same output node.

This is the input

<code>telephone</code>

<item>

<value>

<code>value</code>

</value>

</item>

</element>

</elements>

</telephone>

<email>

<code>email</code>

<item>

<value>

<code>value</code>

<value>info@email.com</value>

</value>

</item>

</element>

</elements>

</email>

<code>website</code>

<item>

<value>

<code>value</code>

<value>www.website.com</value>

</value>

</item>

</element>

</elements>

</website>

</product>

where those <telephone>, <email>, <website> nodes are optional.

while the output should be

<code>contact</code>

<item>

<value>

<name>Telephone</code>

</value>

<value>

<name>Email</code>

<value>info@email.com</value>

</value>

<value>

<name>Website</code>

<value>www.website.com</value>

</value>

</item>

</element>

</elements>

</contact>

</product>

I have no idea I can achieve this using tXMLMap.

Can anyone point me in the right direction?

Thanks.

Re: from different XML nodes to array

David_Beaty — Thu, 08 Apr 2021 13:23:34 GMT

Hi,

You're going to need to construct the whole XML structure as if all the data was coming in (as per your spec above), but ensure that you also enable the option to not generate null/blank entries. You then have to also get the tXMLMap to create the values for <type> and <name> if the <value> is present or blank. IE is the email VALUE is null, then also make the email TYPE null and the email NAME null. When it constructs, it then won't build the whole <value> section at all.

Thanks

David

Re: from different XML nodes to array

solquest — Thu, 08 Apr 2021 13:32:07 GMT

Thanks.

It looks similiar to what I ended up with, when I realized I had no chance to do it in the same tXMLMap where I was mapping all other fields.

So now at first I'm taking only that part of original xml file, creating the output xml structure and store it in a context variable.

After that, in the full tXMLMap I'm writing that context variable in the final xml.

Thanks!

topic Re: from different XML nodes to array in Talend Studio

from different XML nodes to array

Re: from different XML nodes to array

Re: from different XML nodes to array