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
13 - Pulsar

@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