Fuzzy Match Employee Name to Manager Name

Question

Hi folks,

I seek advise on how to make the fuzzy match tool work in the following scenario...

My data has, [Employee ID], [Employee Display Name], [Manager ID], and [Manager Display Name].

I'd like to run the tool to check the display names of both employees and managers and tell me those who are similar enough. I am having problems trying to get this to work bc the data used for the comparison is stored across the two columns.

Thanks!

alexnajm · Accepted Answer

First then, you'll have to use two Select tools to create two streams, use a Formula tool after each to create an "Employee" vs "Manager" label, then Union together making sure that the columns align!