Hi everyone,
Is there an alternative to using Fuzzy Match in this workflow to obtain inexact match data across two different sources? An idea for a different workaround for this?
I am not sure I understand the question, but no there's not another tool in Alteryx to inexact match data across two different sources
I was considering splitting each word from List A into individual words, and doing the same for List B. Then, using a "find and replace" approach, but I'm having trouble coming up with a logical formula to make this work.
As mentioned above, Fuzzy match is really the only way to do something like this, but you are very close to getting it to work. You are only 2 joins away. I would recommend finishing the workflow the way you already have it set up with these minor changes.
1. Change one of the Record IDs to start at a number significantly higher than the other RecordID would ever reach. If for nothing else, it makes it easier to figure out which record IDs are which.
2. The first join is to join on RecordID to bring over the associated name
3. The second join is to join on RecordID2 to bring over the other associated name
You an see the match scores and the names and it looks like this is working as expected!