¿How to sum same column of different files in a tMap?

[EvoticTalend]

I have a flow with multiple excel files in a tFileList and I want to sum a column of different files.

But I have the problem of having the same ID's.

FILE 1

ID - Name - Number

12A - Paul - 5

13A - Jake - 3

FILE 2

ID - Name - Number

14A - Roger - 5

12A - Paul - 2

My current result is an update, of the second file. Paul has 2, not 5 or 7.

I'd want a row with Paul with 7, Jake with 3 and Paul with 2. It is possible?

[gjeremy1617088143]

Hi @Ivan R​ , you can send all your data in a buffer or a hash, then you read the hash and can use a tAggregateRow component to do the sum with a group by by ID.

Send me love and kudos

[Anonymous]

Hello,

That is really good answer, have you thought of entering our competition?

https://community.talend.com/s/blog/aGn5b000000CaZw/getting-smart-about-talend-tip-of-the-day

Best regards

Sabrina

[gjeremy1617088143]

Don’t worry about it Sabrina, I’m in 😉