Mar 13, 2019 03:58 AM
Hi there,
When uploading a new version of a CSV, I have worked out how to add and update existing records.
What I can’t work out how to do is to remove records from the existing table if they have been deleted from a new import.
E.g:
CSV version 1 has 20 records.
CSV version 2 has 18 records - how do I automatically remove these 2 old records from my new updated table after import?
Mar 13, 2019 01:42 PM
Hi @Henry_Taylor,
It seems that this is not a feature that is available yet. I believe it is a safeguard to prevent unwanted data deletion.
If this is something that you think would be useful, maybe create a new request into the ‘Product Suggestions’ and see if other people share this interest.
Mar 14, 2019 03:09 AM
Thanks @Loic_Sanchez. That makes sense, although in some instances where the raw dataset needs to be updated from time to time it would be handy. I’ll raise as a suggestion!
Nov 19, 2020 01:14 PM
I have a similar need…actually, I’d like the ability for the import tool to associate an action with new/changed/deleted records so that I could change a status column to new or deleted if a record has been added/removed on the upload.