[resolved] How to combine multiple ROWS into one row

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,
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.
One Star

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

I think tDenormalize does something like this.
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.
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.