Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Variable from Record to Record 1

Status
Not open for further replies.

pbackstrom

Programmer
Jun 19, 2003
37
US
I would like to have a variable store a value from one record to the next. That is, store a value from the first record, and compare it to the value in the next record coming in.
I tried a wide assortment of things using mapping variables but it seems that even if I use a SETVARIABLE on every record, it doesn't get updated in a way that is visible to the mapping until after the mapping is done running.
Is there any such thing as a real-time mapping variable that is under your control during the run?
 
What you are trying to do cannot be done with mapping variables. You can do what you want but you have to use variables within an expression transformation.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top