parsing an xml input file with nested structure!! looking for help

nivedhitha — Thu, 21 Mar 2019 22:11:51 GMT

Hi,

I have a very lengthy xml input with nested structure that im having difficulties in parsing.

Im providing a portion of the input below

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<FileName>IT_Currency_MSTR_To_PULSE_v4.xml</FileName>

<Name>Standard</Name>

</WeekDay>

</WorkingTime>

</WorkingTime>

</WorkingTimes>

</WeekDay>

</WorkingTime>

</WorkingTime>

</WorkingTimes>

</WeekDay>

</WorkingTime>

</WorkingTime>

</WorkingTimes>

</WeekDay>

</WorkingTime>

</WorkingTime>

</WorkingTimes>

</WeekDay>

</WorkingTime>

</WorkingTime>

</WorkingTimes>

</WeekDay>

</WeekDay>

</TimePeriod>

</WorkingTime>

</WorkingTime>

</WorkingTimes>

</WeekDay>

</WeekDays>

</Calendar>

<Name>Tylor H</Name>

</Calendar>

</Calendar>

<Name>Jerry</Name>

</Calendar>

</Project>

I have to load this data into a db table with the below structure

I tried to parse it with tXMLMap but I can create loop on only 1 node but here I need to loop multiple nodes.

Can someone please help me with this?

Any help is appreciated.

Thank you in advance

Re: parsing an xml input file with nested structure!! looking for help

manodwhb — Fri, 22 Mar 2019 07:08:03 GMT

@nivedhitha ,check the below link may help you.

https://help.talend.com/reader/ixBASPZJ7IvqUQVupZwWbg/EFuE5Nul595D24TRwbFnbw

topic parsing an xml input file with nested structure!! looking for help in Talend Studio

parsing an xml input file with nested structure!! looking for help

Re: parsing an xml input file with nested structure!! looking for help