how to compare two rows in talend

hi team ,
i have to compare two rows in talend how can i do this. on the basis of column B if previous row and current row data is same then we need to populate data in column c in incremental way otherwise put it as 0.
examples are below.
 
input are below.
B,C
0,0
1,0
1,0
active,0
active,0
active,0
active,0
ready,0
want o/p like this 
B,C
0,0
1,0
1,1
active,0
active,1
active,2
active,3
ready,0
how can i do this in talend i use tmemorize component but not able to solve pls help me out resolve this issue.
 thanks in advance
3 REPLIES
Moderator

Re: how to compare two rows in talend

Hi,
For TalendHelpCenter:tMemorizeRows
means to refer to the current row.
means to refer to the previous 1 row. Could you please show us your tMemorizeRows setting screenshot?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Re: how to compare two rows in talend

Hi,
I am not able to share the screen shot.
can you please share the steps/Screen shot to achieve the desired output .
thanks in advance.

Re: how to compare two rows in talend

Can anyone please help me out to resolve above problem.