Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

[SOLVED] Record Duplication Detection, Deduping, and Duplicate Merging

cancel
Showing results for 
Search instead for 
Did you mean: 
Aaron_Owen
7 - App Architect
7 - App Architect
Status: Launched

I would love to have a feature that would search a given table by a field or set of fields to find and surface duplicate rows. It would then be great to be able to take a pre-defined action on duplicated rows such as delete, or merge. Dealing with dupes is always a pain with large data sets or importing new data into a set where some records may already exist. A way to deal with dupes in a somewhat automated way would be really helpful.

93 Comments
Paul_Falcon
4 - Data Explorer
4 - Data Explorer

Same here. It would be great to have this tool.

Tyler_Ridings
4 - Data Explorer
4 - Data Explorer

Same here! Would love to see detection of duplicates.

Raymond_Hou
4 - Data Explorer
4 - Data Explorer

I have a problem with the final step…
Could anyone help me with this: ??
螢幕快照 2018-08-07 23.21.45.png

Laure_Parsons1
4 - Data Explorer
4 - Data Explorer

Please, please, this has been requested for so long and is a pretty obvious feature, especially in a relational database where I want my primary key to be unique!

Patrick1
4 - Data Explorer
4 - Data Explorer

I wonder what the technical issues with this are. Surely at least duplication DETECTION shouldn’t be such a hard thing to implement?

Katherine_Duh
Airtable Alumni (Retired)

We’ll be releasing something on this front soon… :eyes:

Katherine_Duh
Airtable Alumni (Retired)

Hi folks! Our deduplication block is currently in beta right now. You can use it to delete duplicate records or merge individual fields from duplicate records together.

If you’re a Pro plan user and you’re interested in testing it out (and giving us your feedback!), we’d love for you to sign up using this form.

Ariel_Camus
4 - Data Explorer
4 - Data Explorer

Any update on this @Katherine_Duh? The form to sign up doesn’t seem to be available anymore.

Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

The form loaded fine for me by clicking the link @Katherine_Duh posted above:
(just now)
image.png

And I can update you that the beta is live. I have been able to try out the De-duping block.

Kamille_Parks
16 - Uranus
16 - Uranus

They have officially released a de-duplication block for pro users. More information here: https://support.airtable.com/hc/en-us/articles/360008332253