One Star

Merge multiple rows with different field values into one row?

Hi, I would like to merge two rows into one from the same source csv file
 ????????????????????????????????????????????????????
? id ? date ? uid ? source ? pageviews ?
????????????????????????????????????????????????????
? 1 ? 2013-12-11 ? 111 ? source1 ? 14 ?
? 3 ? 2013-12-11 ? 111 ? source1a ? 1 ?
? 11 ? 2013-12-11 ? 222 ? source1 ? 3 ?
? 19 ? 2013-12-11 ? 222 ? source1a ? 11 ?
????????????????????????????????????????????????????

Would become:
 ???????????????????????????????????????????????????
? id ? date ? uid ? source ? pageviews ?
???????????????????????????????????????????????????
? 1 ? 2013-12-11 ? 111 ? source1 ? 15 ?
? 2 ? 2013-12-11 ? 222 ? source1 ? 14 ?
???????????????????????????????????????????????????

I would drop the old id column most likely, it's not important
Thank You Smiley Happy
1 REPLY
Moderator

Re: Merge multiple rows with different field values into one row?

Hi,
Please take a look at TalendHelpCenter:tAggregateRow.
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.