Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
EnriqueLDE
Contributor II
Contributor II

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.

 

0683p000009M1gk.png

 

0683p000009M0xR.png

· Structure

     - Unique ID

     - Group Names separated by commas with the corresponding ID.

Thank you!

 

 

 

Labels (2)
1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

@EnriqueLDE,you can do with tDenormalize component.

 

check below way.

0683p000009M1gp.png0683p000009M1h4.png

View solution in original post

3 Replies
manodwhb
Champion II
Champion II

@EnriqueLDE,you can do with tDenormalize component.

 

check below way.

0683p000009M1gp.png0683p000009M1h4.png

manodwhb
Champion II
Champion II

@EnriqueLDE,is it helped you?

EnriqueLDE
Contributor II
Contributor II
Author

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