I'm trying to detect if I have in my ERP database vendor master file (Great Plains) employee names that reside in a different database (Vista/PDS). I tried joining the two on address ID but that didn't work very well. Is there another way to do something like this?
dhuffman63
Offline
Last seen: 3 years 7 months ago
Joined: 07/18/2019 - 11:20
Sounds like you should be doing a fuzzy match. If you have 11.1 go to the IDEA Lab and check out the Fuzzy Match script (there is also a video on how to use it). If you are using an older version here is a video on how you might want to do it manually - https://www.youtube.com/watch?v=Lu3mwVqE-G4
For some reason I can't get it to extract but it does sound exactly like what I need. I am in 11.1. WFH so that could be the hold up. Not a prioroty right now though...thanks!