Intersection of two tables?

[aditodkar]

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

[Matthew_Lanni · Accepted solution]

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.

[aditodkar]

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?

[Matthew_Lanni]

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.