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

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

EvoticTalend — Fri, 15 Nov 2024 23:46:02 GMT

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?

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

gjeremy1617088143 — Tue, 07 Sep 2021 09:37:39 GMT

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

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

Anonymous — Fri, 10 Sep 2021 02:37:28 GMT

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

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

gjeremy1617088143 — Fri, 10 Sep 2021 16:53:46 GMT

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