Importing CSV files

[pedrocano]

Hi, I'm currently importing CSV files to a table. I've managed to make the import, but the problem now is that everytime I import a new CSV file to the same table, the old records get deleted, and I need to keep those records, so my question is: is there any way to avoid this?

[SkrOYC]

Deleted or updated? You may be also importing the Row_Key column?

[pedrocano]

True, they're updated, my bad.

[Steve · Accepted solution]

The imported rows must have new key column values. If an imported row has the key column value of an existing row, the imported row will replace the existing row.

[pedrocano]

Thanks, it worked.

[SkrOYC]

Or you could just left the key column out of the CSV, and make sure to have a good initial value expression for it, like UNIQUEID()