We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Enhanced functionality for Find Nearest Tool

Hi,

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.