Merge multiple rows with different field values into one row?

[Anonymous]

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

[Anonymous]

Hi,
Please take a look at TalendHelpCenter:tAggregateRow.
Best regards
Sabrina