Getting current and previous values
Posted: Mon Nov 26, 2007 2:53 am
I'm havuing a column PERS_ID.
I need to get the current and previous values on each run.
My stage variables:
PrevPersId : CurrPersId
CurrPersId : InputLnk.PERS_ID
(Initial Value=0)
I'm using two nodes configuration file. I have used hash partition. Data are spliting in two nodes.
Input
111
111
111
222
333
444
555
666
666
Actual Output:
Previous Current
0 222
222 333
333 444
444 555
0 111
111 111
111 111
111 666
666 666
Expected output
Previous Current
0 111
111 111
111 111
111 222
222 333
333 444
444 555
555 666
666 666
Plz help me in this issue.... Thanks in advance
I need to get the current and previous values on each run.
My stage variables:
PrevPersId : CurrPersId
CurrPersId : InputLnk.PERS_ID
(Initial Value=0)
I'm using two nodes configuration file. I have used hash partition. Data are spliting in two nodes.
Input
111
111
111
222
333
444
555
666
666
Actual Output:
Previous Current
0 222
222 333
333 444
444 555
0 111
111 111
111 111
111 666
666 666
Expected output
Previous Current
0 111
111 111
111 111
111 222
222 333
333 444
444 555
555 666
666 666
Plz help me in this issue.... Thanks in advance