How to identify the duplicate records

nagarjuna900 · Post by **nagarjuna900** » Sun Apr 18, 2010 8:33 am

Hi,

In source the data as follows ( having two columns).

1 AAA
2 BBB
1 AAA
3 CCC
1 AAA

The required output as follows.

1 AAA
1 AAA D ( Duplicate Record)
1 AAA D ( Duplicate Record)
2 BBB
3 CCC

( In third column the flag needs to display)

Thanks a lot,

chulett · Post by **chulett** » Sun Apr 18, 2010 9:13 am

One way - add a Sort stage and set Create Key Change Column to True. The new column will help you identify the duplicates.

chulett · Post by **chulett** » Sun Apr 18, 2010 9:16 am

Please don't post the same question multiple times, it just tends to upset the natives. If you wanted to change the Subject you used, edit your post rather than posting it again.

Please delete your other post - you can do this as long as you do it before anyone replies to it. Edit: OK, never mind, too late for that now.