Flat to XML with multiples loop in same level

Highlighted
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

View solution in original post


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

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Creating a Stewardship Campaign and Data Model

In this video, you will see how to create a new campaign and enable team members to address curation tasks assigned to them within an approval workflow process

Watch Now

Managing a Stewardship Campaign

In this video, you will see how to assign your best team members specific tasks to reconcile, correct, merge, arbitrate or group pre-determined data and achieve quality, clean data in a limited time

Watch Now

Talend Data Stewardship – What does it have to offer?

In this short series, you will see how Talend Data Stewardship transforms your employees into data citizens and enables them with self-service capabilities to control their quality data

Watch Now