How to retreive previous record into the output

hemaarvind1 · Post by **hemaarvind1** » Fri Nov 09, 2012 1:19 pm

Hi everyone,

I am using a dataset as a source file. Can someone please suggest how to retreive a previous record with reference to the current record in the file.

Thank you in advance.

rameshrr3 · Post by **rameshrr3** » Fri Nov 09, 2012 3:31 pm

Use stage variables to capture the column values from previous records. This has been discussed many time sin this forum. In transformer stages after v 8.5 you can also user a loop or maybe some of the functions. If you need it for lookup with the same dataset - self reference, copy the dataset ( or the subset of it needed for lookup) to another dataset and use a lookup stage .