I thought DemandTools enabled merging records where you’re matching on fields like the following. No-brainer, right?

It doesn’t, unless you use a hide-your-eyes ugly workaround.

The details:

Look at how none of the dummy records above has the same blanks.

You’d think DemandTools’ “Blank Values” checkbox would handle those inconsistencies, yah? Wrong!

“Blank Values” enables this kind of match:

It does not enable this kind of match:

The fix for this is a goofy workaround which is marginally acceptable if you’re only matching on two fields, but gets exponentially worse with each additional matching field. Boo.

I’ve submitted this as a feature request on DemandTools’ site, but I’m astonished this isn’t out-of-the-box capability.

How did I sporadically use DemandTools for years before noticing this?