Removing Duplicates ---Uncommon Scenario

[kumar444]

I am stuck at this case finally:

Code: Select all

id          bid_no
200       AC634
200       AC455

I need to extract above two records from the remaining records,which are different from other cases.

The rule is :
if ids are equal , i need to check if their bid_nos start With AC but numerical is not equal .
In this case 634<>455.

Can we acheive this? If so how. Thanks...

[SURA]

Yes, that is the condition you need to give using stage variables.

1) sv1 = sv2
2) sv2 = in.colname
3) sv3 (in.desc1=in.desc2)

Rest you need to try.

DS User