topic Re: how to compare two rows in talend in Talend Studio

how to compare two rows in talend

Anonymous — Wed, 11 May 2016 09:08:13 GMT

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

Re: how to compare two rows in talend

Anonymous — Thu, 12 May 2016 08:26:37 GMT

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

Re: how to compare two rows in talend

Anonymous — Thu, 12 May 2016 08:34:45 GMT

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

Anonymous — Fri, 13 May 2016 08:31:50 GMT

Can anyone please help me out to resolve above problem.