Help

Appending new column data to existing table

1393 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Murray_Spork
4 - Data Explorer
4 - Data Explorer

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.

Thanks

1 Reply 1
Richard_York
5 - Automation Enthusiast
5 - Automation Enthusiast

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.