We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

How to use Fuzzy logic for Name

Comments

7 comments

  • Avatar
    Infogix Support
    Originally posted by: Jagdev

    Hi Experts,

    Any views on the above request.

    Regards,
    Jagdev
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: Jagdev

    Hi Experts,

    Any update on this please.

    Regards,
    Jagdev
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: awilliams1024

    Here is an example of using the Fuzzy X-Ref node.
    The example on the left uses only fuzzy matching as there are no match keys defined on the Exact tab.
    The example on the right uses a combination of exact matching on the 'Type' field and fuzzy matching on the 'NAME' field.

    Fuzzy_Matching_Names.brg
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: Jagdev

    Hi A,

    Thanks for the code. I am also looking for the percentage of match. Is it possible?

    Regards,
    Jagdev
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: awilliams1024

    Hi Jagdev,

    See the "FuzzyScoreOutputField" property on the Optional tab:

    "If set, the value will be used as the name of a field in the Unique Match and the MultiMatch output pins. This field contains the fuzzy scores of the data."

    The score value is not a percentage match as such and the meaning of the score depends on the fuzzy algorithm used e.g. for Levenshtein it represents the number of character edits (insert, delete or substitution) that are required to transform one string into the other string. However the score provides a measure of the match (see the node help/tooltip for the 'FuzzyAlgorithm' property for additional information).

    Regards,
    Adrian
    0
    Comment actions Permalink
  • Avatar
    Ishwari Mahajan

    Hi Adrian I wanted to see that code, as I am having similar problem of name mismatch but I am unable to import .brg file in Data3sixty analyse. Could you please help.

    Thanks

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    The .brg file was created by the Lavastorm product but can be imported into Data360 Analyze using the Import > Legacy data flow menu option

     

    0
    Comment actions Permalink

Please sign in to leave a comment.