Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Match Function Formula

vishwa1979
7 - Meteor

Dear Team,

 

I want to add two column's in the given data.

 

> Match % - It will reflect the % of name matching between two columns ( RESPONSE_FULL_NAME / PT_PARTNER_DESC )

> If % is matching above 75 % then = Yes / No

 

Thanks in advance

2 REPLIES 2
aatalai
15 - Aurora

@vishwa1979 take a look at the workflow attached and let me know how you get on, there are more advance techniques like jacquard similarity scoring too look at it

vishwa1979
7 - Meteor

Hi,

 

I want all the cases with match %.

Even its 0 % match then that case should also be available.

Labels
Top Solution Authors