Apr 12, 2019 03:56 AM
I’m experiencing an issue when importing a CSV file using the CSV import block.
The default behavior is that if one of the matched fields is blank on the CSV but filled-in on Airtable, the importing will remove the filled-in value and replace it with a blank.
I’m sure there cases where this behavior makes sense, but in all cases where I’ve used the import feature my CSV data is actually patchier than Airtable. For example, I often have a field that is filled-in in some cases, but not in others.
I want to incorporate the CSV data into Airtable, without removing any of the existing Airtable data. Is this possible?
Jul 10, 2020 09:41 AM
I’m still interested in this feature. Is there any way to achieve this in Airtable?
Apr 27, 2021 11:29 PM
I’m also having this data, importing Stripe payments report and using charge_id as deduplication identifier.
But I use scripts to populate data from other sources, event-driven.
So when reimporting data with duplications i also want to avoid blank fields (if in imported data the field is blank, and in table not, - I want field be populated not with blank)
Airtable team, any updates on this?
Feb 22, 2023 12:57 PM
Same. Importing without erasing existing data is key, kind of basic functionality.
I get that you could import to a different field and then do some fancy formula stuff in AT, but why?
This functionality was present way back in FileMaker 7 if you go back that far, so surely doable?