How to loop and retrieve data based on attribute value of an element

KiranGer — Sat, 16 Nov 2024 00:19:28 GMT

I am new to Talend. I am designing a job to parse xml data. tFileInputXML -> tXMLMap -> tLogRow

I have an part of xml like this below.

<Items>

</anyType>

<Status>Placed</Status>

<Type>Strict</Type>

</anyType>

<Name>Convector 1</Name>

</anyType>

<Status>NotPlaced</Status>

<Type>NotStrict</Type>

</anyType>

</Items>

Could some one tell me how i can loop anyType in tXMLMap based on xsi:type = "Convector " or "Coil" and retrieve its child values. i.e If anytype xsi:type = "Convector" then loop

Name, Weight , OuterDiameter, InnerDiameter values and log in tlogRow1 and If anytype xsi:type = "Convector" then loop status, version, type values and log in tlogRow2.

Thanks for the help in advance.

Re: How to loop and retrieve data based on attribute value of an element

tnewbie — Mon, 05 Apr 2021 21:48:55 GMT

From what I understand, In tXMLMap, set your sourceloop to </anytype>, in the next tmap split the data based on the xsi:type

Re: How to loop and retrieve data based on attribute value of an element

KiranGer — Tue, 06 Apr 2021 02:08:09 GMT

Can you tell me how do I split the data based on type ?

topic Re: How to loop and retrieve data based on attribute value of an element in Talend Studio

How to loop and retrieve data based on attribute value of an element

Re: How to loop and retrieve data based on attribute value of an element

Re: How to loop and retrieve data based on attribute value of an element