[resolved] How to combine multiple ROWS into one row

Highlighted
Five Stars

[resolved] How to combine multiple ROWS into one row

Hi all,
I have the following data:
companyID, notesPageNum, notes1, notes2
1,1,"Notes Paragraph one","Notes Paragraph two"
1,2,"Notes Paragraph three","Notes Paragraph four"
1,3,"Notes Paragraph five","Notes Paragraph six"
2,1,"Notes Paragraph one","Notes Paragraph two"
2,2,"Notes Paragraph three","Notes Paragraph four"
2,3,"Notes Paragraph five","Notes Paragraph six"
2,4,"Notes Paragraph seven","Notes Paragraph eight"
2,5,"Notes Paragraph nine","Notes Paragraph ten"
3,1,"Notes Paragraph one","Notes Paragraph two"
3,2,"Notes Paragraph three","Notes Paragraph four"
3,3,"Notes Paragraph five","Notes Paragraph six"

I want to merge all of this 11 lines to get just one line, may somebody help me please?
I want to get something like this:
1,1, 1,2, 1,3, .."Notes Paragraph one, Notes Paragraph three, Notes Paragraph five..","Notes Paragraph two, Notes Paragraph four, Notes Paragr.."
Thanks,
Highlighted
Moderator

Re: [resolved] How to combine multiple ROWS into one row

Hi,
Have you tried to use tMap to map all your input rows into one output row?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
One Star

Re: [resolved] How to combine multiple ROWS into one row

I think tDenormalize does something like this.
Highlighted
Five Stars

Re: [resolved] How to combine multiple ROWS into one row

Hi all,
I have find another way to solve this problem.
Thanks you to your help.
Highlighted
Moderator

Re: [resolved] How to combine multiple ROWS into one row

Hi IDEMBELE,

Thanks for your feedback. Would you mind sharing  your solution with us?

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog