topic Re: [resolved] How to combine multiple ROWS into one row in Talend Studio

[resolved] How to combine multiple ROWS into one row

Anonymous — Mon, 19 Jan 2015 15:07:48 GMT

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,

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

Anonymous — Wed, 21 Jan 2015 08:01:49 GMT

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

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

_AnonymousUser — Thu, 22 Jan 2015 12:23:20 GMT

I think tDenormalize does something like this.

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

Anonymous — Mon, 26 Jan 2015 09:51:11 GMT

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

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

Anonymous — Tue, 27 Jan 2015 09:03:08 GMT

Hi IDEMBELE,

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

Best regards
Sabrina

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

since_1995 — Wed, 24 Aug 2022 16:56:06 GMT

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