Is it possible to stop some rows to being matched when they have a particular column value?

Question

Hi there,

I am running a matching project in which I have to de duplicate some rows.

I am wondering if it is possible to stop some records to being matched having some kind of pre-condition or whatever needed. 

For example:

I am only interested in the matching between sources A and B, not matching between source A together. In this case, I would like to remove the row highlighted in red from the matching process.

Is it possible?

Thanks and best regards,

Joss

Answer 1

I see your request. When building matching rules, we don't have a rule condition that says Similarity=NotEqual as a prerequisite to make sure only to consider Source <> Source column.

Similarity=Exact

Similarity=Similar

You could export all the Matching Results to a table (not the Survivor Results), and run a TSQL query to peel apart the clusters, and eliminate the values in matching clusters where SOURCE ID is exact match.

Thanks, Jason

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

Answer 2

Thanks Jason,

We were doing something similar, but I just wanted to confirm it.