FUZZY MATCH line by line

[lilyyangadsk]

Hello Sir,

i have question need help.

One, do you know how to line by line get fuzzy match score number using fuzzy match function? 

Second , how to make decimal to set only 2 decimal.

thank you very much!

[grazitti_sapna]

@lilyyangadsk, 

1. For getting a match score. Follow the below configuration.

2. To set decimal to 2 decimal. Use the select tool and change the int type to fixed decimal set size 19.2

I hope this helps!

Thanks!

[lilyyangadsk]

thank you for quick reply, but sometimes we have large data that have similar names in one pool, and i want to only line by line match each account name vs end user name like attached, it seems not working. it mix with other line account name doing fuzzy matching.

[grazitti_sapna]

@lilyyangadsk, will it be possible for you to post the output that you desire? It will be helpful in order to achieve the desired result.

Thanks!

[lilyyangadsk]

sample attached,  how to force alteryx fuzzy match function to only output matchscore to show what the end user name similarity score with same line account name provided. If excel, we are able to do it. 

[grazitti_sapna · Accepted solution]

@lilyyangadsk, I have not heard of any forced Fuzzy but yes to get the desired result you can join the end result.

In that case, I am able to get the records as mentioned in the sample file as required. It might not be the best solution but it is working for me.

I hope this helps!

Thanks!

[lilyyangadsk · Accepted solution]

thank you, it works!

[grazitti_sapna · Accepted solution]

@lilyyangadsk , Glad it worked!