DSXchange

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

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?

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").