Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Duplicate check

328 0
cancel
Showing results for 
Search instead for 
Did you mean: 
sreevi14
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello,

I'm trying to perform duplicate check in a table and have only unique records maintained in the table.
For Example: 
ID Name

0000 ABC

0000 ABC

This should return one unique row and update the table.

Can it be done via automations? Looking for the steps here. Thanks.

3 Replies 3
Alyssa_Buchthal
8 - Airtable Astronomer
8 - Airtable Astronomer

If you have scripting available in your automations, you can delete records from a scripting step. Do you want to merge any fields in the duplicate records, or just delete one entirely?

Automation usually created to be triggered by some record (new or changed). But of course, you can insert script step, which will process all table and the trigger might be a schedule for daily or weekly use.
You can do this by scripting Extension (somewhere in Examples you can find a script to remove duplicates), you can use Deduper Extension or you can do it manually, create new linked field (to a new table), copy-paste whole primary field there, and then add data you need by lookups. In duplicated records, all data will be present, so to avoid repeating, you can use rollup ARRAYUNIQUE(values).

It's for one-time action. If you need to do it from time to time, use Extension.
Or you can check it once and then setup automation to check each new record for duplicates.

Thank you for the response. I would like to retain one unique record