Wednesday, June 27, 2012 4:32 PM
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.
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,
Wednesday, June 27, 2012 7:30 PMModerator
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.
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.
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
- Marked As Answer by Joss83 Thursday, June 28, 2012 8:22 AM
Thursday, June 28, 2012 8:23 AM
We were doing something similar, but I just wanted to confirm it.
- Edited by Joss83 Thursday, June 28, 2012 10:29 AM