community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Fuzzy Match

Saratnarendran
7 - Meteor
‎06-17-2024 07:55 AM

Hi all,

 

I have 2 files as attached and I need to do a fuzzy match between both using the name column. Then what I need to have is the workflow to return a temporary file along with a prompt ("continue once match is identified") showing the similarity % between both also with a flag column "Y/N" so that user can confirm if they are same or not. Once he/she confirms it and saves the file and run the prompt, proceed to next step

 
Name - File 1SalaryDate of SalaryDepartment
John Doe685002024-01-12Marketing
Jane Smith720002023-11-18Finance
Emily Johnson540002024-05-07Human Resources
Michael Brown850002024-03-21IT
Jessica Davis650002023-10-14Sales
Christopher Wilson580002024-02-28Customer Service
Amanda Taylor900002024-06-19Research and Development
David Anderson765002024-04-03Operations
Sarah Thomas615002023-12-25Legal
Matthew Martinez690002024-05-30Administration

 

Name - File 2SalaryDate of SalaryDepartment
Michael Brown855002024-01-09IT
Emily Johnson542002023-10-15Human Resources
John Doe687002024-02-10Marketing
Jane Smith723002024-03-12Finance
Jessica Davies653002024-04-15Sales
Christopher Wilson580002024-05-10Customer Service
Amanda Taylor902002024-06-19Research and Development
David Anderson768002024-04-22Operations
Sarah Thomson615002023-11-11Legal
Matthew Martinez693002023-12-08Administration
Johnathan Doe685002024-05-12Marketing
J. Smith720002024-06-15Finance
Emily Johnston547002024-01-05Human Resources
Michelle Brown845002024-03-28IT
Jessica Davis650002024-02-17Sales
Chris Wilson586002023-10-23Customer Service
Mandy Taylor900002024-05-19Research and Development
David Andersen765002024-01-13Operations
Sarah Thomas612002024-04-10Legal
Matt Martinez683002024-06-25Administration
Emily Johnson540002024-02-22Human Resources
Michael Browne853002023-11-30IT
John Doe685002024-03-14Marketing
Amanda Taylor901002024-06-08Research and Development
Jane Smith721002024-02-18Finance
Christopher Wilson583002023-12-17Customer Service
Sarah Thompson613002024-01-25Legal
David Anderson763002024-05-20Operations
Jessica Davis652002024-06-02Sales
Matthew Martinez691002024-02-27Administration

 

Required temporary output file as below with "Y/N" column for the user to confirm if they are matched or not and after confirming save this temporary file and hit continue to proceed to next step of the workflow

Name - File 2SalaryDate of SalaryDepartmentSimilarityName - File 1SalaryDate of SalaryDepartment
Michael Brown855002024-01-09 0:00IT0.00%    
Emily Johnson542002023-10-15 0:00Human Resources71.25%Emily Johnson540002024-05-07 0:00Human Resources
John Doe687002024-02-10 0:00Marketing74.49%John Doe685002024-01-12 0:00Marketing
Jane Smith723002024-03-12 0:00Finance70.78%Jane Smith720002023-11-18 0:00Finance
Jessica Davies653002024-04-15 0:00Sales0.00%    
Christopher Wilson580002024-05-10 0:00Customer Service70.25%Christopher Wilson580002024-02-28 0:00Customer Service
Amanda Taylor902002024-06-19 0:00Research and Development98.96%Amanda Taylor900002024-06-19 0:00Research and Development
David Anderson768002024-04-22 0:00Operations0.00%    
Sarah Thomson615002023-11-11 0:00Legal71.25%Sarah Thomas615002023-12-25 0:00Legal
Matthew Martinez693002023-12-08 0:00Administration0.00%    
Johnathan Doe685002024-05-12 0:00Marketing80.95%John Doe685002024-01-12 0:00Marketing
J. Smith720002024-06-15 0:00Finance63.80%Jane Smith720002023-11-18 0:00Finance
Emily Johnston547002024-01-05 0:00Human Resources85.04%Emily Johnson540002024-05-07 0:00Human Resources
Michelle Brown845002024-03-28 0:00IT64.38%Michael Brown850002024-03-21 0:00IT
Jessica Davis650002024-02-17 0:00Sales63.80%Jessica Davis650002023-10-14 0:00Sales
Chris Wilson586002023-10-23 0:00Customer Service0.00%    
Mandy Taylor900002024-05-19 0:00Research and Development86.38%Amanda Taylor900002024-06-19 0:00Research and Development
David Andersen765002024-01-13 0:00Operations64.38%David Anderson765002024-04-03 0:00Operations
Sarah Thomas612002024-04-10 0:00Legal0.00%    
Matt Martinez683002024-06-25 0:00Administration52.81%Sarah Thomas615002023-12-25 0:00Legal
Emily Johnson540002024-02-22 0:00Human Resources68.67%Emily Johnson540002024-05-07 0:00Human Resources
Michael Browne853002023-11-30 0:00IT69.59%Michael Brown850002024-03-21 0:00IT
John Doe685002024-03-14 0:00Marketing71.25%John Doe685002024-01-12 0:00Marketing
Amanda Taylor901002024-06-08 0:00Research and Development84.57%Amanda Taylor900002024-06-19 0:00Research and Development
Jane Smith721002024-02-18 0:00Finance82.66%Jane Smith720002023-11-18 0:00Finance
Christopher Wilson583002023-12-17 0:00Customer Service71.70%Christopher Wilson580002024-02-28 0:00Customer Service
Sarah Thompson613002024-01-25 0:00Legal87.86%Sarah Thomas615002023-12-25 0:00Legal
David Anderson763002024-05-20 0:00Operations0.00%    
Jessica Davis652002024-06-02 0:00Sales69.59%Jessica Davis650002023-10-14 0:00Sales
Matthew Martinez691002024-02-27 0:00Administration0.00%    
Preview file
12 KB
Preview file
11 KB
Labels:
Reply
0 Likes
1 REPLY 1
griffinwelsh
12 - Quasar
‎06-17-2024 02:21 PM

I've attached a fuzzy match workflow to get the desired temporary output. You can use a chained app to run this workflow and then pause until you end user has modified the final column and wants to proceed.

Fuzzy match.yxmd
Reply
0 Likes
Fall Release Webinar
Labels
Top Solution Authors
View All