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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.