Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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