Page 1 of 1

Capturing duplicate records using sort stage

Posted: Mon May 28, 2012 9:14 pm
by phanikumar
Hi,

I need to capture duplicate records along with the master record using sort stage. Can somebody explain how to achieve this.

I tried to perform this by creating the key change column set to TRUE and I tried to filter on Key change column =0 which eliminates master record.

Any tips to achieve this ?


Regards
Kumar

Re: Capturing duplicate records using sort stage

Posted: Mon May 28, 2012 9:42 pm
by thirupathireddy.gankidi
Write two filter conditions

1)filter on Key change column =0 which gives duplicate records.
2)filter on Key change column =1 which gives unique records.