Help

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

Re: import csv - duplicates insert

627 1
cancel
Showing results for 
Search instead for 
Did you mean: 
sreevi14
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, 

I'm trying to import csv files into existing tables and wanted to perform upsert/insertion of only new records by comparing it with the records in the existing table.

I'm using import csv extension to accomplish this, but ended in duplicate records for some rows. The merge operation is not accomplishing the task of avoid insertion of duplicate rows if its already present in the existing table.

Message: Detected records with merge field value "". All matching records will be overridden to match the first matching row.

In this case, its neither overriding nor avoiding the row and inserting both two rows with the same value resulting in duplication.
 The Merge column chosen is unique.
Can someone assist with this issue.



6 Replies 6

Hello @sreevi14 
There are 2 more options you can use. Both of them are after completing your csv import process.

1) Use the Dedupe extension https://support.airtable.com/docs/dedupe-extension
2) Extension script for deleting multiple duplicates.

See the attached screenshot.

dilipborad_0-1723874116831.png

👍

ScottWorld
18 - Pluto
18 - Pluto

@sreevi14 

Personally, I don’t use Zapier, because Make is infinitely more powerful & significantly cheaper than Zapier.

I wrote a thread on this topic here: https://air.tableforums.com/t/make-vs-zapier/737

If you use Make’s CSV modules along with Make’s Airtable modules, you can “upsert” the records on their way into Airtable.

The “upsert module” means that Make will automatically either: (1) create a new record or (2) update an existing record, depending on whether that record already exists in Airtable based on any search criteria that you specify.

I demonstrate how to do this CSV importing/upserting process step-by-step on this Airtable podcast episode.

— ScottWorld, Expert Airtable Consultant

Hello,

Your problem may be due to the fact that there are records in your table with empty values for the field used  for the merge check. You should filter your table on empty values for this field to check it is the case.

Regards,

Pascal

Thank you!

Thank you! I will check that out!

The merge field isn't unique and had duplicate values. Hence the issue. Thank you for the response.