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
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
Don't forget to give kudos when a replay is helpful and click accept the solution when you think you're good with it.
Thirteen Stars

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

@EnriqueLDE,is it helped you?

Manohar B
Don't forget to give kudos when a replay is helpful and click accept the solution when you think you're good with it.

All Replies
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
Don't forget to give kudos when a replay is helpful and click accept the solution when you think you're good with it.
Thirteen Stars

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

@EnriqueLDE,is it helped you?

Manohar B
Don't forget to give kudos when a replay is helpful and click accept the solution when you think you're good with it.
Five Stars

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

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

Cloud Free Trial

Try Talend Cloud free for 30 days.

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.