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.