topic Re: Merge TFileInputExcel rows (f.e. using tMap) in Talend Studio

Merge TFileInputExcel rows (f.e. using tMap)

EnriqueLDE — Fri, 14 Dec 2018 12:05:38 GMT

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.

· Structure

- Unique ID

- Group Names separated by commas with the corresponding ID.

Thank you!

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

manodwhb — Fri, 14 Dec 2018 12:40:30 GMT

@EnriqueLDE,you can do with tDenormalize component.

check below way.

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

manodwhb — Mon, 17 Dec 2018 04:10:23 GMT

@EnriqueLDE,is it helped you?

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

EnriqueLDE — Tue, 18 Dec 2018 09:37:41 GMT

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