Import CSV Overwrite existing data

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?

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.

1 Like

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?

1 Like

Yes.

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

1 Like