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,
How to identify the duplicate records
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Mon Dec 29, 2008 2:22 am
- Location: chennai
![Exclamation :!:](./images/smilies/icon_exclaim.gif)
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers