Creating Fuzzy Matching functionality in Anaplan

jimfeng5 · 2023-04-04T21:07:04+00:00

There was an error rendering this rich post.

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

Accepted answers

pyrypeura

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.

All comments

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.

pyrypeura

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.

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

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…