Compare results in two tables


#1

Hello,

I’ve created a base by importing two separate CSV files as tables. Each table contains a list of email addresses. I’d like to easily be able to find email address that are in both tables. How do I go about that? Thanks! (new to Airtable)


#2

Create a third table with a formula that performs a comparison of the two tables/fields and outputs either the email address when they appear in both or a variable such as ‘yes’ to indicate that they appear in both.

You will still need a mechanism to trigger the creation of records on the third table. I’d use Zapier to Add a Record on View Change. Set the View to Main on the second table and when you import the records on both tables it will trigger the creation of a record on the third table that performs the necessary comparison.