Anmelden
 
HomeLibraryDownloadsSupportWebcasts & EventsCommunityForenBlogs
Ressourcen für IT-Professionals >
> 
> 
Is it possible to stop some rows to being matched when they have a particular column value?

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

  • Mittwoch, 27. Juni 2012 16:32
     
     
    Anmelden
    0

    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

     

Alle Antworten

  • Mittwoch, 27. Juni 2012 19:30
    Moderator
     
     Beantwortet
    Anmelden
    0

    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

    • Als Antwort markiert Joss83 Donnerstag, 28. Juni 2012 08:22
    •  
     
  • Donnerstag, 28. Juni 2012 08:23
     
     
    Anmelden
    0

    Thanks Jason,

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


    • Bearbeitet Joss83 Donnerstag, 28. Juni 2012 10:29
    •