Merge TFileInputExcel rows (f.e. using tMap)

Five Stars

Merge TFileInputExcel rows (f.e. using tMap)

Hello, 
I am new to Talend. I would like to merge the rows at the first picture (from a single TFileInputExcel) to get a TFileOutputExcel like the second picture.

 

excel_1.PNG

 

excel_2.PNG

· Structure

     - Unique ID

     - Group Names separated by commas with the corresponding ID.

Thank you!

 

 

 


Accepted Solutions
Highlighted
Thirteen Stars

Re: Merge TFileInputExcel rows (f.e. using tMap)

@EnriqueLDE,you can do with tDenormalize component.

 

check below way.

Untitled.pngUntitled.png

Manohar B
Thirteen Stars

Re: Merge TFileInputExcel rows (f.e. using tMap)

@EnriqueLDE,is it helped you?

Manohar B

All Replies
Highlighted
Thirteen Stars

Re: Merge TFileInputExcel rows (f.e. using tMap)

@EnriqueLDE,you can do with tDenormalize component.

 

check below way.

Untitled.pngUntitled.png

Manohar B
Thirteen Stars

Re: Merge TFileInputExcel rows (f.e. using tMap)

@EnriqueLDE,is it helped you?

Manohar B
Five Stars

Re: Merge TFileInputExcel rows (f.e. using tMap)

Thank you very much Manohar B, you helped me a lot. It works perfectly!

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.