This content has been marked as final. Show 1 reply
Finding the exact matches is comparatively easy but the second part - suggestions for similars - is a bit harder.
First the easy part: Create a relationship from person::name to employee::name and a calculation field count(relationshipJustCreated::ID). If the calculation field shows exactly one you can transfer the data with script step 'set field'. It might be sufficient to transfer the ID.
The second part needs some testing. If there are not to many records a calculation on both sides = Left(
name ; 1 ) and a relationship connecting both could do the job. If that shows to many hits you can increase the 1 to a convenient value. But all this will fail if the first letter is written differently on both sides.