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

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch