compare two records in DataStage

[amar.v023]

Hi All,

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

Any idea please share...

[srinivas.nettalam]

Please put the values in tabular format so that it will be easy for you to pose your question..

[123gopal]

can be use Aggregator stage for that or compare the two records using join or merge stage after that use aggregater stage

[srinivas.nettalam]

can be use Aggregator stage for that or compare the two records using join or merge stage after that use aggregater stage

Apparently,there are no common values expected in the two sets so we cannot porceed with the combining stages.However you can try compare stage but even that stage requires same values in the columns as per my understading

[vmcburney]

You might be able to do something with a Transformer loop - this lets you step through the values of records across more than one row and output rows based on what you find. This Transformer looping functionality was new in version 8.5 (I think) and is in every version since. You would need to partitioning and sorting to make sure row A and B come into the transformer in a row.