Steve Berger
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.