Need both parent and child loop in tXMLmap component

One Star

Need both parent and child loop in tXMLmap component

Hi,
Is it possible to have both parent and child loop in tXMLmap for processing XML. If not, please suggest a component which can extract all the child loop element for every parent loop.
PFB the expected result and xml format.
<parent id="498292">
    <dobs>
        <dob>1900</dob>
<dob>1910</dob>
    </dobs>
<pobs>
        <pob>INDONESIA</pob>
    </pobs>
</parent>
<parent id="1233">
    <dobs>
<dob>1950</dob>
    </dobs>
<pobs>
        <pob>INDIA</pob>
<pob>IRAN</pob>
    </pobs>
</parent>
<parent id="4568">
    <dobs>
<dob>1970</dob>
<dob>1990</dob>
    </dobs>
<pobs>
        <pob>IRAQ</pob>
<pob>INDIA</pob>
    </pobs>
</parent>
</parents>

EXPECTED RESULT:
PARENT DOB POB
498292 1900 INDONESIA
498292 1910 INDONESIA
1233         1950 INDIA
1233         1950 IRAN
4568         1970 IRAQ
4568         1990 INDIA
Community Manager

Re: Need both parent and child loop in tXMLmap component

Hi
It is impossible to extract multiple loop elements at once, however, you can extract each loop element separately, and then do an inner join between these extracted records based on parent id to merge the data. 
Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business