Help

Re: Intersection of two tables?

Solved
Jump to Solution
804 0
cancel
Showing results for 
Search instead for 
Did you mean: 
aditodkar
4 - Data Explorer
4 - Data Explorer

I have 2 tables each have one common column i.e website. How can I generate 3rd table which will be intersection of table 1 and table 2?

Note: I am using airtable free plan

1 Solution

Accepted Solutions
Matthew_Lanni
7 - App Architect
7 - App Architect

If you go ahead and make a third table, you can then turn your website fields into linked fields and link them to the third table.

That should do what you want, though I'm unsure about free plan limitations in this area.

See Solution in Thread

3 Replies 3
Matthew_Lanni
7 - App Architect
7 - App Architect

If you go ahead and make a third table, you can then turn your website fields into linked fields and link them to the third table.

That should do what you want, though I'm unsure about free plan limitations in this area.

Is there any way to move records from table A to table B with one click?

Currently I have to select all records and then Ctrl+C + Ctrl V to new table. Instead can I just group and filter records and then move in single click?

If you turn your website fields into linked fields, that should auto-populate your third table with data without you having to move anything manually.

Here's an example base: https://airtable.com/shrM1Q8ApOCxWyzDL

If you want to see additional info from tables 1 and 2 within table 3, you'll need to use lookup fields.