10-07-2024 12:46 PM
Is there a way to create a scenario to check for duplicate accounts that are NOT the same record type? I can see where I can create a filter for a specific Record type or use it as a matching criteria, but I would like to so potential duplicates between record types only.
10-09-2024 09:36 AM
@FCZ - Can you share more detail on what you are looking to acheive? You are looking to dedupe an object but only want to dedupe those that don't share the same record type, is that correct? Or only compare objects of a certain record type?
10-09-2024 09:46 AM
Hello! The former. I am looking to find potential duplicates around different record types only. I do recognize that I can just pull all record types, but that would require me to go in and remove any duplicate groups that are for the same record type so I can focus on the cross dupes only. Hope this helps.
10-09-2024 11:42 AM
Certainly, so this is a job for the Filter Match Results feature in Dedupe. It will take a little engineering depending on your specific data and criteria but will aid in not having results be all the same, everytime. Filter Match Resuls tells Demandtools to return match sets where a condition is met AT LEAST once per match set.
For example, in the screenshot above, if most of my records are account type Customer, using the Filter Match Results criteria above, I would ensure all my results in the preview grid had at least one record with the an account type other than customer. Let me know if you have any additional questions!
10-10-2024 09:06 AM
thanks for this, however, this still pulls duplicates within the same record types, just removes a specific one.
Get industry news, expert insights, strategies, and hot tips, served up fresh every week.
Visit the Validity blog