Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

CSV Import App - limitations on matching fields

Topic Labels: Extensions
Solved
Jump to Solution
305 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

1 Solution

Accepted Solutions

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.

See Solution in Thread

3 Replies 3

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.

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.

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!