Appending new column data to existing table


I’m finding that this scenario is pretty common and I’m wondering if there is built-in support for this or if there is a work-around.

I’m extracting data from salesforce via CSV dumps into airtable - however I often find that I’m missing something - there is some new field I need to add to the extracted data - after I’ve already done some work extracting and cleaning up the first extract.

How can I merge data into a new column from a second CSV extract to an already existing table - assuming I have a common key field in the existing table and the new CSV file? The exact records however may not fully match - i.e. some records may have been deleted - some added - since the first extract.



Well, you could always create a new table with the key and the additional column and then link the two back to the existing table via the key.