Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesHi,
I would like to see an option within the 'Find Nearest Tool' (and maybe other Tools like it) to exclude from results when a particular Target field equals a particular Universe field. This could be added right under the 'Ignore 0 Distance Matches' in config window. You could have drop-downs (like a filter tool) to pick the fields etc. Example of what I'm doing: One Address may have multiple accounts and it's in Target and Universe. Ignoring 0 Distance would drop all the other Accounts at the same address. I only want it to ignore the Universe Address if it has the same Account Number and the Target Account Number. That is a little deeper drill than just ignore 0 Distance but not too hard to add.
As it stands, I don't ignore 0 Distance. I have a formula after the 'Find Nearest' to drop Target Acct Nbr = Universe Acct Nbr. Then a 'Multi-Row Formula' tool to fix the find nearest order. This works, but I thought it might be nice to have it in the tool.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.