Re: Dedupe and Blank Fields

664 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

The Dedupe block seems to match black fields. This makes the Dedupe block not very useful. Is there anyway to exclude blank fields?

2 Replies 2

You’re talking about the fields that you’re manually choosing to match for deduping, right?

Since you know in advance which fields that you will be choosing for your match, what I would recommend is just create a new view that filters out any records that are blank in those fields.

Then, you can run the dedupe on only the records that are displaying in that view.

6 - Interface Innovator
6 - Interface Innovator

thanks for the response, sorry im not being clear.

So if I have a contact database and I’m checking to “dedupe” records which have the same email address, it’s not helpful to have it suggest 38 contacts without email addresses are the same person. Seems like a lot of work to filter out blank fields. When would anyone ever under any circumstances consider two records each with a matching blank field to be the same record?