Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (2)
3 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

Can anyone please help me out to resolve above problem.