Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Match strings exactly or pretty close to each other between two datasets

tanvir_khan
8 - Asteroid

Hi all:

 

I've two datasets as below and I need to match those by Name. Sample datasets with dummy values along with desired output is given below. Idea is to match Names of dataset-A and dataset-B (pick all the exact matches plus values match very closely). I've tried to apply fuzzy tool but it's not providing me the accurate result. May be I've not configured the tool correctly. Need help guys. 

 

Dataset-A

NAME-A
BRENDAN PETER
NATHAN BILL
BRIAN LEE
BRUCE AKIN
FREDDY LAM
JASON J
PETER FOLD

 

Dataset-B

NAME-BASSET NO
BRENDAN PETER5551
BRENDAN PETER SIM2121
NATHAN BILL6677
NATHAN BILL IPAD9911
NATHAN BILL LAPTOP2111
BRIAN LEE PHONE8811
DIANA MILLER7999
DIANA MILLER LAPTOP8080
BRUCE AKIN2232
BRUCE AKIN9988
LAPTOP FREDDY LAM3343
FREDDY LAM IPAD1121
JASON J5421

 

Output

NAME-ANAME-BASSET NO
BRENDAN PETERBRENDAN PETER5551
BRENDAN PETERBRENDAN PETER SIM2121
NATHAN BILLNATHAN BILL6677
NATHAN BILLNATHAN BILL IPAD9911
NATHAN BILLNATHAN BILL LAPTOP2111
BRIAN LEEBRIAN LEE PHONE8811
BRUCE AKINBRUCE AKIN2232
BRUCE AKINBRUCE AKIN9988
FREDDY LAMLAPTOP FREDDY LAM3343
FREDDY LAMFREDDY LAM IPAD1121
JASON JJASON J5421

 

Thanks

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @tanvir_khan 

 

In this scenario you can use find replace.

 

Here is a workflow for the task.

Output:

atcodedog05_0-1606456042741.png

Workflow:

atcodedog05_1-1606456059233.png

 

Hope this helps 🙂 Feel to ask if you have any questions


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @tanvir_khan 

 

Cheers and Happy Analyzing 😀

 

Feel free to reach out if you face any issues 🙂

tanvir_khan
8 - Asteroid

Appreciate that. I was trying to apply wrong tool.

I applied this tool before but overlooked it has the option 'Any Part of Field'

Thanks man!

Labels