to store column value of previous rec

karrisuresh · Post by **karrisuresh** » Tue Jan 06, 2009 7:10 pm

Hi
while loading the 7th rec, In the transformer I want to store the column value of 6th rec and add that column value to 7th rec based on certain condition and populate it to tgt,

Only thing is I am not getting idea as how to get the value of 6th rec which already populated into the tgt table just before this 7th record

Any help would be really great

Thanks
Suresh

ArndW · Post by **ArndW** » Tue Jan 06, 2009 7:27 pm

This is a classic example of the use of stage variables and works in both Server and PX jobs. If you have a stage var "LastValue = In.ColumnName" then any stage var defined before that assignment will have the value from the last value. In PX jobs you need to take the partitioning into account, though.