Hi, I am fairly new to Alteryx and have been working on building a (for me) fairly complex model.
I face an issue with fuzzy matching where I wnat to determine the match score for two names at the same company - see table below.
I followed hese instructions: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Comparing-Records-between-two-columns-...
See for structure of the input table attached (CEO is always the same person for a company, Supervisor sometimes is the same as CEO). The goal is to identify when Supervisor and CEO are the same person.
My output from fuzzy match only provides a score for a few companies but its typically dozens of rows that are repeated (see screenshot attached). I have no idea why.
Would be very grateful for help on this.
Hi @ChrisD2,
Please see these articles and reply for any assistance needed.
Prepare two inputs for Fuzzy Match Merge