# How to keep duplicates? (inverse remove duplicates)

**URL:** <https://community.parabola.io/t/how-to-keep-duplicates-inverse-remove-duplicates/1323>\
**Category:** Ask a question\
**Created:** [November 28, 2020, 7:11pm UTC](https://community.parabola.io/t/how-to-keep-duplicates-inverse-remove-duplicates/1323 "2020-11-28T19:11:15Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nathan\_Lively](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/nathan_lively/32/729_2.png) [@Nathan\_Lively](https://community.parabola.io/u/Nathan_Lively)\
**Post date:** [November 28, 2020, 7:11pm UTC](https://community.parabola.io/t/how-to-keep-duplicates-inverse-remove-duplicates/1323/1 "2020-11-28T19:11:15Z")

</div>

How do I complete a reverse of Remove Duplicates?

I tried Find Overlap and Combine Tables and Filter rows. Nothing is working as expected.

The result I’m looking for is to remove duplicates from my Bubble Database.  
Bubble import \> Keep Duplicates \> Bubble Export with Delete command

---

<div class="post-metadata">

**Author:** ![andrew](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/andrew/32/36_2.png) [@andrew](https://community.parabola.io/u/andrew)\
**Post date:** [November 29, 2020, 10:26pm UTC](https://community.parabola.io/t/how-to-keep-duplicates-inverse-remove-duplicates/1323/2 "2020-11-29T22:26:32Z")

</div>

Hey @Nathan_Lively! You can use the `Insert row numbers` step. In the advanced settings, add in the `Number based on...` option and choose a column with a unique identifier (in example below, using Group #). You’ll get something that looks like this:

 ![Screen Shot 2020-11-29 at 14.23.36](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/c/cc039b637ac2d7c0f74b7cca928a06a7ceb8311f.png).

You can then add in a `Filter rows` step to remove where Row Number = 1.

Does that make sense?

---

<div class="post-metadata">

**Author:** ![Nathan\_Lively](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/nathan_lively/32/729_2.png) [@Nathan\_Lively](https://community.parabola.io/u/Nathan_Lively)\
**Post date:** [November 29, 2020, 10:27pm UTC](https://community.parabola.io/t/how-to-keep-duplicates-inverse-remove-duplicates/1323/3 "2020-11-29T22:27:34Z")

</div>

That makes sense! I’ll try it.

---

<div class="post-metadata">

**Author:** ![Nathan\_Lively](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/nathan_lively/32/729_2.png) [@Nathan\_Lively](https://community.parabola.io/u/Nathan_Lively)\
**Post date:** [November 30, 2020, 2:51pm UTC](https://community.parabola.io/t/how-to-keep-duplicates-inverse-remove-duplicates/1323/4 "2020-11-30T14:51:16Z")

</div>

So far it seems like it’s working. Thanks!

---

<div class="post-metadata">

**Author:** ![andrew](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/andrew/32/36_2.png) [@andrew](https://community.parabola.io/u/andrew)\
**Post date:** [November 30, 2020, 4:13pm UTC](https://community.parabola.io/t/how-to-keep-duplicates-inverse-remove-duplicates/1323/5 "2020-11-30T16:13:53Z")

</div>

Awesome, glad to hear @Nathan_Lively 🙂 @Warren_Lee just added this functionality, so we all have him to thank!!

---

<div class="post-metadata">

**Author:** ![Adam\_Walder](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/adam_walder/32/1550_2.png) [@Adam\_Walder](https://community.parabola.io/u/Adam_Walder)\
**Post date:** [July 29, 2021, 11:11pm UTC](https://community.parabola.io/t/how-to-keep-duplicates-inverse-remove-duplicates/1323/6 "2021-07-29T23:11:54Z")

</div>

Thanks @andrew ! Works exactly as I had hoped.