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

[nivedhitha]

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"?>

<Project xmlns="http://schemas.microsoft.com/project">

<SaveVersion>14</SaveVersion>

<FileName>IT_Currency_MSTR_To_PULSE_v4.xml</FileName>

<Calendars>

<Calendar>

<UID>1</UID>

<Name>Standard</Name>

<IsBaseCalendar>1</IsBaseCalendar>

<IsBaselineCalendar>0</IsBaselineCalendar>

<BaseCalendarUID>-1</BaseCalendarUID>

<WeekDays>

<WeekDay>

<DayType>1</DayType>

<DayWorking>0</DayWorking>

</WeekDay>

<WeekDay>

<DayType>2</DayType>

<DayWorking>1</DayWorking>

<WorkingTimes>

<WorkingTime>

<FromTime>08:00:00</FromTime>

<ToTime>12:00:00</ToTime>

</WorkingTime>

<WorkingTime>

<FromTime>13:00:00</FromTime>

<ToTime>17:00:00</ToTime>

</WorkingTime>

</WorkingTimes>

</WeekDay>

<WeekDay>

<DayType>3</DayType>

<DayWorking>1</DayWorking>

<WorkingTimes>

<WorkingTime>

<FromTime>08:00:00</FromTime>

<ToTime>12:00:00</ToTime>

</WorkingTime>

<WorkingTime>

<FromTime>13:00:00</FromTime>

<ToTime>17:00:00</ToTime>

</WorkingTime>

</WorkingTimes>

</WeekDay>

<WeekDay>

<DayType>4</DayType>

<DayWorking>1</DayWorking>

<WorkingTimes>

<WorkingTime>

<FromTime>08:00:00</FromTime>

<ToTime>12:00:00</ToTime>

</WorkingTime>

<WorkingTime>

<FromTime>13:00:00</FromTime>

<ToTime>17:00:00</ToTime>

</WorkingTime>

</WorkingTimes>

</WeekDay>

<WeekDay>

<DayType>5</DayType>

<DayWorking>1</DayWorking>

<WorkingTimes>

<WorkingTime>

<FromTime>08:00:00</FromTime>

<ToTime>12:00:00</ToTime>

</WorkingTime>

<WorkingTime>

<FromTime>13:00:00</FromTime>

<ToTime>17:00:00</ToTime>

</WorkingTime>

</WorkingTimes>

</WeekDay>

<WeekDay>

<DayType>6</DayType>

<DayWorking>1</DayWorking>

<WorkingTimes>

<WorkingTime>

<FromTime>08:00:00</FromTime>

<ToTime>12:00:00</ToTime>

</WorkingTime>

<WorkingTime>

<FromTime>13:00:00</FromTime>

<ToTime>17:00:00</ToTime>

</WorkingTime>

</WorkingTimes>

</WeekDay>

<WeekDay>

<DayType>7</DayType>

<DayWorking>0</DayWorking>

</WeekDay>

<WeekDay>

<DayType>0</DayType>

<DayWorking>1</DayWorking>

<TimePeriod>

<FromDate>2017-10-28T00:00:00</FromDate>

<ToDate>2017-10-28T23:59:00</ToDate>

</TimePeriod>

<WorkingTimes>

<WorkingTime>

<FromTime>08:00:00</FromTime>

<ToTime>12:00:00</ToTime>

</WorkingTime>

<WorkingTime>

<FromTime>13:00:00</FromTime>

<ToTime>17:00:00</ToTime>

</WorkingTime>

</WorkingTimes>

</WeekDay>

</WeekDays>

</Calendar>

<Calendar>

<UID>3</UID>

<Name>Tylor H</Name>

<IsBaseCalendar>0</IsBaseCalendar>

<IsBaselineCalendar>0</IsBaselineCalendar>

<BaseCalendarUID>1</BaseCalendarUID>

</Calendar>

<Calendar>

<UID>4</UID>

<Name>MAS</Name>

<IsBaseCalendar>0</IsBaseCalendar>

<IsBaselineCalendar>0</IsBaselineCalendar>

<BaseCalendarUID>1</BaseCalendarUID>

</Calendar>

<Calendar>

<UID>5</UID>

<Name>Jerry</Name>

<IsBaseCalendar>0</IsBaseCalendar>

<IsBaselineCalendar>0</IsBaselineCalendar>

<BaseCalendarUID>1</BaseCalendarUID>

</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

[manodwhb]

@nivedhitha ,check the below link may help you.

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