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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!