[resolved] How to combine multiple ROWS into one row

[Anonymous]

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,

[Anonymous]

Hi,
Have you tried to use tMap to map all your input rows into one output row?
Best regards
Sabrina

[_AnonymousUser]

I think tDenormalize does something like this.

[Anonymous]

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

[Anonymous]

Hi  IDEMBELE,

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

Best regards
Sabrina

[since_1995]

I need the solution for the same issue, but just for one column i,e

Column1

test1

test2

test3

test4

test5

something like this

test1%7Ctest2%7Ctest3%7Ctest4%7Ctest5

can someone please provide the solution