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!
@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!
thank you, it works!
@lilyyangadsk , Glad it worked!
@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
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.
