Aug 16, 2024 11:59 AM
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.
Aug 16, 2024 10:55 PM
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.
👍
Aug 17, 2024 12:38 AM - edited Aug 17, 2024 12:39 AM
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
Aug 18, 2024 03:41 AM
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
Aug 19, 2024 04:38 PM
Thank you!
Aug 19, 2024 04:39 PM
Thank you! I will check that out!
Aug 19, 2024 04:39 PM
The merge field isn't unique and had duplicate values. Hence the issue. Thank you for the response.