topic Re: Sum based on row value in Talend Studio

Sum based on row value

Anonymous — Sat, 16 Nov 2024 04:26:42 GMT

My input is

Balls,Valid Ball,Runs
1,Y,0
2,Wide Ball,1
3,No Ball,4
4,Y,2
5,Y,6
6,Y,0
7,Wide Ball,1
8,Wide Ball,1
9,Y,4
10,Y,4
11,Y,6
12,Y,0
13,Y,0
14,No Ball,1
15,No Ball,1
16,Wide Ball,4
17,Wide Ball,3
18,Y,6
19,Y,6
20,Y,6

Need Output as

over,runs

1,23

2,33

Re: Sum based on row value

TRF — Tue, 08 Oct 2019 07:56:41 GMT

Do we have to guess the logic for going from the input to the output?

Re: Sum based on row value

Anonymous — Tue, 08 Oct 2019 08:26:40 GMT

oops..forgot to mention that

Over is of 6 Balls, Count 6 Valid Balls for 1 Over.'Y' means its a valid ball

Re: Sum based on row value

TRF — Tue, 08 Oct 2019 08:32:39 GMT

Sorry, I don't play cricket, just play Talend!
Can give more details?

Re: Sum based on row value

Anonymous — Tue, 08 Oct 2019 08:35:15 GMT

need to sum the runs column for 1st 6 'Y's (need to include no ball, wide which comes within 1st 6 valid balls) then for the 2nd 6 'Y's and so on

Re: Sum based on row value

TRF — Tue, 08 Oct 2019 10:01:34 GMT

Here is my proposal:

You need some logic with tMap local variables:

Sum are computed with tAggregateRow component with the following settings:

And the result is:

Starting job test at 11:00 08/10/2019.

[statistics] connecting to socket on port 4014
[statistics] connected
.----+----.
|tLogRow_13|
|=---+---=|
|over|runs|
|=---+---=|
|1   |23  |
|2   |33  |
'----+----'

[statistics] disconnected
Job test ended at 11:00 08/10/2019. [exit code=0]

Re: Sum based on row value

Anonymous — Tue, 08 Oct 2019 10:54:19 GMT

can you please help me with the logic used in the tmap.

Re: Sum based on row value

TRF — Tue, 08 Oct 2019 11:05:16 GMT

No time for detailed explications.
You have to know local variables are evaluated in the order they are defined.
Start by copying to your job for test then try to decompose manually step by step, it's the better approach to learn (maybe using paper and pen).

Also don't forget to mark your case as solved (Kudos also appreciated).