LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  How to compare fields and calculate probability of match by fieldname ?

    Employee
    Posted 08-25-2015 06:14

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Akintosh1

    Hello

    Im pretty new at Lavastorm

    How can i compare fields in a Excelfile and get the probability of match by their fieldname ?

    Example:


    Field 1 : xyz

    Field 2 : xyzSE

    Probability : 60% Match


  • 2.  RE: How to compare fields and calculate probability of match by fieldname ?

    Employee
    Posted 12-18-2015 08:12

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: mgajdosik

    This is very difficult question to answer, since you need to define your algorithm for calculating the probability...

    xyAzB and xyz matches 60% or 40%

    also Axyz and xyz matches 0% or 75%

    You can use fussy join node for this which allows you to determine algorithm and deviation in some cases. For example Levensthein distance would tell you how many characters needs to be added/removed or modified for strings to be same. Using this distance you can create your own match probability by dividing distance by length of string. It is up to you to decide whether you want to use max length of strings or average or min one.

    Marek