topic Dedupe Account Name with "The Group" x "Group" x "Group" in DemandTools

Dedupe Account Name with "The Group" x "Group" x "Group"

nicobolar09 — Fri, 11 Aug 2023 07:13:37 GMT

Hi DTV Community,

I'm using the Dedupe to try and clean up some duplicated Account records but have found a challenge I can't seem to get working.

I have a scenario where I'm matching on Account Name to identify merge candidates. I have 3 duplicate records that are not being identified by DTV:

Account 1 Name = "The Clear Group (New York, NY)"
Account 2 Name = "Clear Group (New York, NY)"
Account 3 Name - "Clear Group (New York, NY)"

DTV is identifying Account 2 and 3 as Dupes, but not 1. I need Account 1 to be the winner in this scenario.

Thank you in advance!

Regards,

Nico

Re: Dedupe Account Name with "The Group" x "Group" x "Group"

AnthonyValidity — Fri, 11 Aug 2023 11:25:20 GMT

Hi @nicobolar09 ,

The longterm solution for this type of scenario is to use the Cleaned Account Name comparison type. You would also want to add "The" to the prefix tab within that window. You get there by going to Cogwheel > Manage Cleanse Rules > Prefix. Once you add "The" to the prefix tab, any account name starting with The will have it removed when DemandTools 5.x attempts to match on the account name. Account #1 would then match to #2 and #3.

Click here to go to the Cleaned Account Name explanation in our article. Click here for the Manage Cleanse Rules article.

Hope this helps!

Re: Dedupe Account Name with "The Group" x "Group" x "Group"

nicobolar09 — Fri, 11 Aug 2023 14:27:45 GMT

Thanks for this Solution, I just change the Cogwheel > Manage Cleanse Rule > Replace added "The " to "" and it work!

Re: Dedupe Account Name with "The Group" x "Group" x "Group"

AnthonyValidity — Fri, 11 Aug 2023 15:04:50 GMT

Great! By the way, I don't think the space after the "The" is necessary as the system will account for the space after it. Either way, I'm glad it worked!