DSXchange

Posted: **Thu Sep 22, 2011 4:51 pm**

I am stuck at this case finally:

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

Posted: **Thu Sep 22, 2011 4:53 pm**

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

DSXchange

Removing Duplicates ---Uncommon Scenario