Importing CSV from Make.com (Integromat)

[Henry_Taylor]

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?

[Loic_Sanchez]

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.

[Henry_Taylor]

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!

[Steve_Edberg]

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.