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
How to use entries in previous record in next record.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 47
- Joined: Wed Apr 12, 2006 12:13 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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 47
- Joined: Wed Apr 12, 2006 12:13 pm