cancel
Showing results for 
Search instead for 
Did you mean: 

Limiting the dup pairs to the ones with only two duplicate record

NA
Frequent Contributor

 

Hi, we have a situation that when there is only two records in a dup pair - the winner is clear.

If there are three or more duplicate records in a dup-pair, it usually means something requires human intervention.

Is there any way to make the Merge Managemnt aka review duplicate process,  limit the results to only those dup-pairs with only two?

Thanks

 

1 ACCEPTED SOLUTION

NA
Frequent Contributor

Works like a charm - Thanks - Neil

View solution in original post

4 REPLIES 4

Pugs_Validity
Validity Team Member
Validity Team Member

@NA - Not particularly but what is it that makes your winner clear? When you get instances of more than one duplicate record, is it typically an situation where you have two winners or two losers?

NA
Frequent Contributor

Fair question:

Unfortunately, a member of our IT team unintentionally ran a process that created 16,000 anonymous households. The goal here is to reunite these anonymous households with the correct account that they were created from.

To create the rule that the anonymous household will always be the loser - that part was straightforward .
And when there is only one record dupe - then the winner is easy to identify.
When there is three or more than it is not clear cut.
So the goal is to create a subset of only two record pairs - so Demand Tools can do it's stuff. 
Am I making sense?

Pugs_Validity
Validity Team Member
Validity Team Member

@NA - Ah, gotcha. When you setup your Winner Rule, turn the Score Delta on, it shouldn't matter what number you have it at, as long as it's greater than zero. Once that's on, if the two non-anynonmous households are in a set with a anonymous household, Demandtools won't select a winner in that set due to them scoring the same value and not meeting the score delta threshold. You should then only be left processing those that have one non-anonymous. Additionally, you can then manually review or apply a 2nd or 3rd Winner Rule for the sets of 3+. Make sense?

Pugs_Validity_1-1753305962637.png

 

 

NA
Frequent Contributor

Works like a charm - Thanks - Neil