Creating Fuzzy Matching functionality in Anaplan

jimfeng5
jimfeng5
in Modeling

Hi all Anaplanners,

Does anyone have any insights in build the fuzzy matching functionality inside of Anaplan to identify the likelihood of duplicated strings ( company name, rep name, etc)? Alteryx have the fuzzy matching functionality and that's pretty much what I want to replicate inside Anaplan as well.


Thanks,

Jim

Best Answer

  • pyrypeura
    pyrypeura
    Answer ✓

    Agree with @andrewtye !

    In theory you could try to do for example Jaro algorithm to calculate similiraties of text items but that wouldn't really be something where Anaplan is at it's best.

Comments

  • andrewtye
    andrewtye

    Hi @jimfeng5

    Can you not pass the data back from Alteryx - afterall right tool, right job.

    IMO data should be coming out of transactional systems as clean as possible afterall you're just storing up problems for later down the line if it isn't.

  • jimfeng5
    jimfeng5

    Yeah that is exactly what I do now in alteryx. This is more like a mini project I am exploring for fun (no life!). Thanks for replying @andrewtye @pyrypeura

Categories