How can we capture change in one column value

gauravpec · Post by **gauravpec** » Thu Mar 01, 2007 4:07 am

Hi we have a column first_name and we want a column index that will be generated once the value in first_name is changed . How can we perform this thanks a lots :?:

chulett · Post by **chulett** » Thu Mar 01, 2007 8:28 am

Welcome!

That's not alot of information to work on. Typically, in a Server job, existing values of a field would be loaded into a Hashed File and then a reference lookup would be used to determine if the value was being changed.

Does that help?

ray.wurlod · Post by **ray.wurlod** » Thu Mar 01, 2007 3:30 pm

Use stage variables to detect when last_name and first_name change. Use those to trigger updates to the "change has occurred" column (which you have referred to as a "column index").