Anyone can help Fuzzy Grouping

  • Any1 hav any idea to use sql statement get value like _inscore,_keyin,Column_Clean?

    Then as for threshold purpose is?

  • Hey,

    Fuzzy Grouping attempts to group database row based on the similarities in a string column (also does exatct matching on other datatypes). The similiarity threshold for the string matching is controllable via the threshold setting, any matches exceeding the threshold aren't grouped. The columns you listed are the results of this transformation, ie [_keyout] is the key to the canonical row its matched againest, therefore all rows with the same key are a matched group.

    Is this helping???

  • Then is there any libraries to use to create this funcytion in visual studio project or using sql statement to do the fuzzy grouping except usin g dts package??

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply