Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Don’t worry about it Sabrina, I’m in 😉