Field Merge

With Field Merge, you can merge data at the individual field level from multiple records with precision. Evaluate and combine specific fields based on predefined criteria, such as selecting the most frequent entry, concatenating values, summing numeric fields, or creating a comprehensive list of all field values. This enables precise control over merging duplicate data based on field specifics.

Here are the results of all the configured Field Merge Criterion (Append, Join, Add Up, Most Frequent Values).

1. Append: Now you can easily merge data from the fields of subordinate records into a single field in the master record, separated by your chosen delimiter. Example: If you have a master lead record and several subordinate lead records that have different product interests. You can now combine all the product interests from these related records into one field in the master lead record, separated by a colon or any separator of your choice. In order to merge record fields based on the “Append” merge criterion, follow the steps below:

• Navigate to Sales Hub → Lead Entity → Select and open the record for which you want to detect and merge duplicates based on the 'Append' field merge criteria → Click on the 'Show Duplicates' button.

• Select all the duplicate records and click on the “Merge” button.

• Now click “Finish” to combine all the values from the subordinate records into a single master record.

• Now all the values (Product Interests) from the subordinate records will be combined in the “Interested in products” field of the master record.

1. Join: With this criterion, you can merge all the selected options from the multi-select option set fields of subordinate records with a master record. Example: If you have multiple lead records for the same person in your CRM, each with different "Contact Preferences," you can merge these into a single, comprehensive list in the master lead record. By using the Join merging criterion, all selected preferences from the duplicate records are combined, ensuring no information is lost during the merge. In order to merge record fields based on the “Join” merge criterion, follow the steps below:

• Navigate to Sales Hub → Lead Entity → Select and open the record for which you want to detect and merge duplicates based on the 'Join' field merge criteria → Click on the 'Show Duplicates' button.

• Select all the duplicate records and click on “Merge” button.

• Now click “Finish” to combine all the options from the subordinate records in the master record.

• Now all the options (contact preferences) from the subordinate records will be combined in the “Contact Preferences” field of the master record.

1. Add Up: With this criterion, you can sum all the values in the numerical fields of the subordinate record with the master record while merging. Example: You have duplicate lead records for the same person in your CRM, each containing different budget values in the “Budget” field based on their product interests. Using the Add Up merging criterion, you can automatically sum these values into a single comprehensive total, which is then stored in the master lead record. In order to merge record fields based on the “Add Up” merge criterion, follow the steps below:

• Navigate to Sales Hub → Lead Entity → Select and open the record for which you want to detect and merge duplicates based on the “Add Up” field merge criteria → Click on the 'Show Duplicates' button.

• Select all the duplicate records and click on the “Merge” button.

• Now click “Finish” to sum all the values (Budget Amount) from the subordinate records in the master record.

• Now all the values (Budget Amount) from the subordinate records will be summed up in the “Budget Amount” field of the master record.

1. Most Frequent Value: With this criterion, you can take the most common value among the master and subordinate records and set it in the master record while merging. Example: If your CRM has duplicate lead records for the same person, all with the same company name in the Company Name field. Using the Most Frequent Value merging option, you can ensure the company name that appears most often is retained in the master record after merging. In order to merge record fields based on the “Most Frequent Value” merge criterion, follow the steps below:

• Navigate to Sales Hub → Lead Entity → Select and open the record for which you want to detect and merge duplicates based on the “Most Frequent Value” field merge criteria → Click on the 'Show Duplicates' button.

• Select all the duplicate records and click on the “Merge” button.

• Select the most common value (Company Name) among the master and subordinate records and click “Finish” to set it in the master record.

• Now the most common value from the subordinate and master records will be set in the master record.

This is how you can merge field values based on various field merging criteria.