Flat to XML with multiples loop in same level

Five Stars

Flat to XML with multiples loop in same level

Please, we need to create a mapper to convert Flat to XML with multiple loops at the same level. I attached the example that I am trying to do.

 

@hnie


Accepted Solutions
Highlighted
Employee

Re: Flat to XML with multiples loop in same level

The input here contains rows of different countries and their languages and cities.

I think you need to use a 1st map to group countries to the output then a 2nd map to distinct languages and cities of each country.

 

Please see the attachment for details.

 

Steps below explain how to get it

  • 1st map to group countries

01.png02.png03.png

  • 2nd map to distinct languages and cities

04.png05.png06.png

  • to chain 1st map with the 2nd

07.png08.png


All Replies
Highlighted
Employee

Re: Flat to XML with multiples loop in same level

The input here contains rows of different countries and their languages and cities.

I think you need to use a 1st map to group countries to the output then a 2nd map to distinct languages and cities of each country.

 

Please see the attachment for details.

 

Steps below explain how to get it

  • 1st map to group countries

01.png02.png03.png

  • 2nd map to distinct languages and cities

04.png05.png06.png

  • to chain 1st map with the 2nd

07.png08.png

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.