-
Harmonizing step setup
Hi there, I was trying to create a priority on the harmonizing step to choose an email based on a score but it's not working. I checked everything to see what's wrong but couldn't find anything, can you help me? I am using the same rules on other fields for example to choose the most recent phone and address on the…
-
Harmonize Duplicate based on recent data
Is there a way to select only the recent record while doing the data merging and selecting the golden record
-
Harmonize Duplicates - Select best record based on score with multiple criteria
A customer posted this question to me: "I want to pick a survivor using multiple score based criteria in the Harmonize step. So when all records in a cluster have the same survivor code ( a number I create) I need it then to pick the record with the newest date. For example two records in a cluster might have survivor…
-
Smart Harmonization FAQ
As of release 2.4.5, you are able to turn on a preview of a new feature that involves smart models utilizing machine learning for harmonization. The smart models can be applied as Column specific rules at the additional options for Harmonize duplicates. What is harmonization? Harmonization is used to merge, blend or reduce…
-
Selecting Best Record with Harmonize Duplicates
There are times when you just want a quick way to deduplicate your data without necessarily knowing how many duplicates are found. For example, you have a list of course completion status for a course OL100. There are multiple statuses recorded on different dates for each user. However, you are only interested in the…
-
ℹ️ Removing Exact Duplicates / Exact Matches
A common thing users want to do with Data Studio is remove rows with (exact) duplicate values in selected columns, similar to the functionality in Excel 'Remove Duplicates' that will compare values in the selected columns, keeping the first of any exact matches, but also keep the values from any unselected columns in that…
