Skip to main content
All CollectionsFAQGeneral
Merging Data in Planhat
Merging Data in Planhat

If you have duplicate data in Planhat, you can use some of our tools to merge those records

Christian Dreyer avatar
Written by Christian Dreyer
Updated over a week ago

Planhat's API and Database largely prevent creation of forbidden duplicates. Planhat considers records to be duplicates if they either:

  • have the same sourceId on the same model (i.e. you have 2 endusers with the same sourceId), or

  • have the same externalId and are associated with the same company (or if the records in question are companies, if these companies have the same externalId).

The rules for what is considered a forbidden duplicate, and how Planhat handles attempts to import duplicate data, are explained in greater detail in this article and in our API docs.

If you, for any reason, have duplicate data in Planhat, this may cause problems when attempting to sync with external systems, be it through integrations or via our API.

Records with duplicate Unique Identifiers (UIDs) can therefore be merged using our Powertool for merging forbidden duplicates. You can also merge some records individually.

The Powertool: Merge Duplicate Models

How does the Powertool work?

Model

  • Here you set the model where you want to merge duplicate records.

Order of Merge Process

  • Here you decide which keyable to be processed first in the merge process. This is an important detail. For example, if you first process by sourceId, and then by externalId, then after all duplicate sourceIds are merged, it may be that there are no longer any externalId duplicates. This would be the case if any duplicate externalId values were merged into other records while merging on sourceId.

Prioritise retained data by

  • Here you can set a numeric or date value that you want to use to determine the relative importance of duplicate records. For example, if you have one Enduser created on January 1st 2020, and another that was created on January 1st 2022, then you may generally want to prioritise data on the old record over the new record. In order to prioritise by the oldest created date, you would simply pick "created date" and "ascending", meaning that the smallest date value is given highest priority.

What data is merged using the Powertool?

The Powertool merges all fields on duplicate records on the selected model. In other words, Planhat will first identify records which have the same sourceId, or the same externalId on the same Company, and will then populate a single duplicate record with data from the other duplicates. This includes:

  • fields of any type - including list, multipicklist, team member, team members

πŸ“Œ Please note that User Activities and Custom Metrics will not be merged, instead, the record which is "retained" through your priority setting, will also retain its metrics.

Merging from Profiles

Sometimes, you come across duplicates while browsing the platform. Rather than merging all data in bulk, according to Planhat's de-duplication rules, you may want to merge the record individually. This is available for Companies and Endusers.

In order to do this, go to the ellipsis in the top right of the Company or Enduser Profile, and select "Merge with other Profile" or "Merge with other contacts" for Companies and Endusers, respectively.

You can read more about merging individual records here, for Companies, and here, for Endusers!

Did this answer your question?