How to use entries in previous record in next record.

sylvan_rydes · Post by **sylvan_rydes** » Fri Jul 21, 2006 3:46 pm

Hi All,

This is something new for me. I have an ETL job with some value added processing. Here I need to use the values of current record to define some columns of next record. I don know how to keep track for the entries in previous record. Any help would be appreciated.

Thanks in advance.

Sylvan

chulett · Post by **chulett** » Fri Jul 21, 2006 3:56 pm

Stage Variables can hold the 'previous' values of things so you can use them against the next row that comes along. It's all about declaring them in the proper order.

There's a Tech Tip in this zip file that explains how to do group change detection with stage variables. The technique will also work for you in your situation.

sylvan_rydes · Post by **sylvan_rydes** » Fri Jul 21, 2006 4:19 pm

Hi Craig,

Thank a lot for the reply.

Sylvan