how to assign next value to the current record
Posted: Tue Dec 30, 2008 1:19 am
Hi,
I need help on the following requirement.
I have input in the following format.
Input
-----
A|B
a|5
b|8
c|17
d|35
I need the output in the following format. I need to load B column data into new column (i.e. C) and push one row above.
Output
-------
A|B|C
a|5|8
b|8|17
c|17|35
d|35|
I know we can get this by using stage variables. I tried but i couldn't complete.
Can anybody help me on the same.
Thanks..
I need help on the following requirement.
I have input in the following format.
Input
-----
A|B
a|5
b|8
c|17
d|35
I need the output in the following format. I need to load B column data into new column (i.e. C) and push one row above.
Output
-------
A|B|C
a|5|8
b|8|17
c|17|35
d|35|
I know we can get this by using stage variables. I tried but i couldn't complete.
Can anybody help me on the same.
Thanks..