Import CSV Overwrite existing data

[Remon_Toma]

Hello, i hope someone can help in that.

when i use import csv function to update existing data, so it clear the data already exist if i did not include this column in the imported file. for example if i have four columns in the main database : ID, Name, Address and quantity with ID is the key
then if the imported CSV file only has two columns ID and Quantity then all the data in address and name columns becomes blank.

am i missing something?

[Steve]

I believe that’s expected behavior: the rows of CVS data replace existing rows of the table. It does not merely update the included columns.

[Remon_Toma]

even if these columns are not included at all ( even the header ) in the CSV?
so to update only one column i must include all other columns?

[Steve]

Remon_Toma:

so to update only one column i must include all other columns?

Yes.

[Remon_Toma]

Okay thanks.
i hope in the future u can allow that we can update only one column.

[Allison_Romero1]

I am here to say being able to exclude a column from update if it is not included in CSV would be very helpful. The only workaround I found is an automation to update rows in another table and it takes much more time and energy.