Import CSV and Update Existing Entities (where matches exist)

Get Help
1

Hey folks:
This seems like a simple use case so maybe this is possible and I just can’t figure it out (or find documentation or discussion). There are some cases where I’m importing a CSV into an existing database and – rather than creating a duplicate of an entity – I’d like for it to update the existing entity with the additional information that’s in the CSV.

Right now it seems like it just creates a new entity rather than finding and matching to one that already exists. And I end up manually having to find those and merge them together.

Is there something I’m missing? Thanks much!

2

Hi, Pamela!
It’s not possible indeed

But you can try checking deduplication template in our template gallery - in Advanced category

This template will help to configure process like this:

  1. You import into existing database
  2. Automation find duplicates
  3. Compares those duplicates
  4. Updates one of them with the missing information
  5. Deletes the one with less info
    If smth will be unclear, you can ping us via chat

btw, curious to know where the data is coming from - maybe it will make sense to have integration instead>

1 Like