Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Fuzzy Logic - Compare Strings with a common factor

w_gore
8 - Asteroid

Good evening,

 

I have been trying to determine how to match fields in a joined dataset with a common attribute to each set, with one set having data i want to add to the second set.  The tables each contain an account field that is common to both.  Each table contains a name field; however, that data is in various formats/layout.  The field I want to retrieve is an owner code unique to one table and not the other table. The attached Excel file provides a summary example of the tables and what I am trying to match.  Thanks in advance.

2 REPLIES 2
binuacs
20 - Arcturus

@w_gore One way of doing this with the Fuzzy match

 

binuacs_0-1661939421331.png

 

w_gore
8 - Asteroid

Thanks for the quick response.  That did the trick!  

 

 

Labels