DSXchange

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.

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 .