Is it possible to compare two records in DataStage, then decide what value to add to a new field on each record?
For example, if Record 1 has an 'A' and Record 2 has a 'B' then, add a new field with 'Z' for Record 1 and 'Y' for Record 2. But, if Record 1 has an 'A' and Record 2 has a 'C', the new values would be different. Hopefully that makes a little sense
![Wink ;-)](./images/smilies/icon_wink.gif)
Any idea please share...