how to remove all duplicate values from a column

Question

For some reason when a user is adding a record, it duplicates it three times.

Why is that happening?

enter image description here

Since there is many How can I remove any records that contains a duplicate in a specific column?

do you have the any workflow on the list or any other customization? — Waqas Sarwar MVP, Apr 28, 2015 at 19:28
another thing, i am thinking if you enforce Uniqueness on the JPPNum column then duplicate can avoide — Waqas Sarwar MVP, Apr 28, 2015 at 19:32
I was thinking that but I already have a lot of duplicates, which I need to remove first. so I can do the unquiness option. — Matt Ludwig, Apr 28, 2015 at 19:35

Amal Hashim · Accepted Answer · 2015-04-28 19:30:17Z

2

Two possibilities

Workflow you can check using SharePoint Designer.

Event Receiver - You can download SharePoint Manager and connect to SharePoint server or you can use below PS script

$site = Get-SPSite -Identity "http://siteurl"
$web = $site.RootWeb
$list = $web.Lists["ListName"]
$list.EventReceivers | Select assembly, name, type

answered Apr 28, 2015 at 19:30

Amal Hashim

28.3k5 gold badges30 silver badges61 bronze badges

what kind of workflow would it be?
– Matt Ludwig
Apr 28, 2015 at 19:32
Not sure you can check List Settings -> Workflows and see what all workflows are associated
– Amal Hashim
Apr 28, 2015 at 19:33
where would the ps script go
– Matt Ludwig
Apr 28, 2015 at 19:33
You need to login to Server and open SharePoint Management Shell and execute it
– Amal Hashim
Apr 28, 2015 at 19:35
I don't have access to the management
– Matt Ludwig
Apr 28, 2015 at 19:36

Add a comment |

Waqas Sarwar MVP · Accepted Answer · 2015-04-28 19:37:45Z

0

Looks like you have some kind of Workflow or Event receiver can cause this issue.

you can avoid this in future to implement the Uniqueness on the column.

Now to remove the Duplicate values from list, couple of options.

Option # 1

Option # 2

Please try to open this list as access(link in IE) and run this query in access

SELECT Claim.[Claim Number], Count(*) AS Expr1
FROM Claim
GROUP BY Claim.[Claim Number]
HAVING (((Count(*))>1));

answered Apr 28, 2015 at 19:37

Waqas Sarwar MVP♦

56.9k17 gold badges41 silver badges78 bronze badges

I did option 1 and theres 300 duplicates but scarrtered through out the view. so theres no way to do a specific filter
– Matt Ludwig
Apr 28, 2015 at 19:39
also check this one stackoverflow.com/questions/21331530/…
– Waqas Sarwar MVP ♦
Apr 28, 2015 at 19:40
Does anyone know why when a certain user adds a new record, it is being duplicated but it happens randomly. no event receiver or workflow.
– Matt Ludwig
Apr 29, 2015 at 13:46

Add a comment |

2 Answers 2