Link to home
Start Free TrialLog in
Avatar of Steve Berger
Steve BergerFlag for United States of America

asked on

How to remove identify the duplicate with two distinct rows?

Hi,
   I need to identify the duplicate data with two distinct rows. See my data structure below.
NAME      NAME_1   VALUE    START_DATE      END_DATE      FLAG     INDEX
SURI         SE            275        13/12/2005            31/12/2010         B          1
SURI         SE            375                                                                 A          1
SURI         SE            475                                                                 A          1
SURI         SE            275        13/12/2005            31/12/2010         B          2
SURI         SE           375                                                                  A          2
SURI         SE           475                                                                  A          2
SURI         SE           175        13/12/2006            31/12/2010         B          3
SURI         SE           375                                                                  A          3
SURI         SE           475                                                                  A          3

                This is my sample data. Here data are duplicate with two different index column. INDEX 1 and 2 contains same group of combination. So i need to identify any one of duplicate combination(i.e INDEX 1 or 2). Can anyone come up with exact solution?

Thanks
SOLUTION
Avatar of Lee Wadwell
Lee Wadwell
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial