Going through rows and adding up numbers

[noobTalendDev]

Here is how the data is formatted from my tLogRow (i am reading an xlsx file).

Essentially I want to go through all of these rows and add up the numbers and assign them to the respective users. I am new to talend and couldn't really figure this part out if anyone can provide some guidance.

Input:

user1 | 5|

user2 | 2|

user3 | 1|

user4 | 3|

user1 | 2|

user2 | 6|

user3 | 8|

user10 | 4|

user11|30|

Output:

user1 | 7|

user2 |8|

user3 |9|

user4 |3|

user10|4|

user11|30|

[noobTalendDev]

I ended up using tSurviveFields to fix this issue, anyone else have any other methods of doing this?

[gjeremy1617088143 · Accepted solution]

Hi, you can use tAggregateRow component , you choose the first field as group by element and you select a sum for the second one in Operations.

https://help.talend.com/r/Btf8zDsnT4ikhQgFW1plpQ/RqPO6eM_3ol9LDQojiHXYQ

https://help.talend.com/r/jomWd_GKqAmTZviwG_oxHQ/YYVSsDiyJ3vBHh9357Ds~Q

Send me love and kudos