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
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