Skip to main content

Merging records with same ID

  • September 29, 2020
  • 3 replies
  • 44 views
M
Forum|alt.badge.img

Hey guys. I’m trying to simplify a de-dupe routine.

Scenario: I have a significant amount of records I’m importing. Many have identical IDs but have one multiple-select field that is different. I need to merge those into one record to combine the multiple selects. My manual process has been to do the following:

  1. Copy/paste new data in.
  2. Run De-Dupe App manually, checking every record.

This works, but it’s super time-consuming. I need to automate the process.

Is there any batch process to handle this? It’s always the same result. Needs to merge against the ID. All other fields remain the same, the only change is the multiple-select field.

Ideas?

Thanks.

    3 replies

    kuovonne
    Forum|alt.badge.img+29
    • kuovonne
    • Brainy
    • 6009 replies
    • September 29, 2020

    How often do you need to import new information in? If you need to do this on an ongoing basis, you can do this with a custom script app or custom automation script action.

    There may also be some third party tools that can do this, but the simplest to implement would be a custom script. Then your workflow would be.

    1. Copy/paste new data in.
    2. Click “run” button for the custom script app.

    The script detects the duplicates, merges the multi-select field values, and deletes the extras.

    An automation script could merge the duplicates as well, but would require a bit more to setup and would take up automation runs. Since you have to interact with the user interface already, the additional step of clicking the run button shouldn’t add much to your workflow.

    If you need would like to hire someone to write this script for you, feel free to send me a direct message.

    M
    Forum|alt.badge.img
    • Michael_Bryan
    • Author
    • New Participant
    • 2 replies
    • September 29, 2020

    How often do you need to import new information in? If you need to do this on an ongoing basis, you can do this with a custom script app or custom automation script action.

    There may also be some third party tools that can do this, but the simplest to implement would be a custom script. Then your workflow would be.

    1. Copy/paste new data in.
    2. Click “run” button for the custom script app.

    The script detects the duplicates, merges the multi-select field values, and deletes the extras.

    An automation script could merge the duplicates as well, but would require a bit more to setup and would take up automation runs. Since you have to interact with the user interface already, the additional step of clicking the run button shouldn’t add much to your workflow.

    If you need would like to hire someone to write this script for you, feel free to send me a direct message.


    It’s something I need to do weekly, with a couple thousand records. I’ll DM you.

    G
    Forum|alt.badge.img+1
    • galengkm
    • New Participant
    • 1 reply
    • August 21, 2023

    It’s something I need to do weekly, with a couple thousand records. I’ll DM you.


    Hey Michael, did you ever figure out a solution? I have the same need as you but with less frequency. De-deplucating with merge of 1,400 records one by one is not ideal.


    Terms & ConditionsAccessibility statement