# How to automate de-duplication / deleting double items from database?

**URL:** <https://forum.bubble.io/t/how-to-automate-de-duplication-deleting-double-items-from-database/68164>\
**Category:** Need help\
**Created:** [September 30, 2019, 6:19am UTC](https://forum.bubble.io/t/how-to-automate-de-duplication-deleting-double-items-from-database/68164 "2019-09-30T06:19:05Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![vini\_brito](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/vini_brito/32/22187_2.png) [@vini\_brito](https://forum.bubble.io/u/vini_brito)\
**Post date:** [September 30, 2019, 2:54pm UTC](https://forum.bubble.io/t/how-to-automate-de-duplication-deleting-double-items-from-database/68164/2 "2019-09-30T14:54:54Z")

</div>

Yes, search for the thing you want, group them by whatever field you use to uniquely identify them (for example an ID or code you assign, not the Bubble-assigned unique id), aggregate them by “count”, then filter that list by count \> 1.  
Display that list in a repeating group if you want to see so you know which ones are duplicated, then through their unique identifier you can delete them.  
Or just delete them manually in the database tab if they’re just a few.

---

_[View the full topic](https://forum.bubble.io/t/how-to-automate-de-duplication-deleting-double-items-from-database/68164)._
