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?