Apr 11, 2022 12:10 PM
I am looking for a way to import data from a CSV file but match on more than just one field. The CSV Import App appears to be limited in allowing matching to occur only on one field. Is there an alternative solution to importing data and matching on multiple fields?
My use case is I am importing people who have purchased tickets at a recent event but I know some of the people are already present in the base. I would like to match on Full Name, email address, and Street Address 1 to avoid duplication of existing records while also preventing inappropriate overwriting of data.
Thanks!
Solved! Go to Solution.
Apr 12, 2022 05:52 AM
How many duplicates do you expect to find and how often do you expect to perform the input?
If this is a one time import with few duplicates, you may be better off with importing everything as new and then running the deduce app.
If this will be a frequent occurrence with many duplicates, you may want to import the file and process it with a custom script versus having to manually create a concatenate field in your CSV file every time.
Apr 12, 2022 02:31 AM
The solution that comes to mind is to create a (temporary) field – both in your csv file and in Airtable – that concatenates “Full Name & email address & Street Address 1” : then match on that field during import.
Apr 12, 2022 05:52 AM
How many duplicates do you expect to find and how often do you expect to perform the input?
If this is a one time import with few duplicates, you may be better off with importing everything as new and then running the deduce app.
If this will be a frequent occurrence with many duplicates, you may want to import the file and process it with a custom script versus having to manually create a concatenate field in your CSV file every time.
Apr 12, 2022 07:17 PM
It will be a frequent occurrence with many duplicates. The custom script does sound nice but I don’t think the organization I’m working with has the skillset to create that. The concatenated field may have to be the answer for now.
Thank you!