Goooooood Morning Alteryx!
I have a workflow built to create points and measure distances between each of the destinations "A" and "B", and each household within a list. The product of this is a table similar to the one below. I need to identify which destination has the closest distance, and delete or filter out all of the other rows, output similar to what's shown.
Current Workflow Output
Destination | Household | Distance |
A | Gandalf | 3 |
B | Gandalf | 5 |
A | Frodo | 7 |
B | Frodo | 6 |
A | Sam | 14 |
B | Sam | 23 |
A | Sauron | 65 |
B | Sauron | 73 |
Desired Workflow Output
Destination | Household | Distance |
A | Gandalf | 3 |
B | Frodo | 6 |
A | Sam | 14 |
A | Sauron | 65 |
Thank you!
Solved! Go to Solution.
Have you tried using the 'find nearest' tool? If you Have your destinations in one table, and your households in the other table it should be straightforward to accomplish. The tool has some built-in examples you can look at.
Hi @ijurgensen ,
You can sort your table per household and then distance (in ascending order so sorter distance comes first). Then with a sample tool, you can only keep the first record per household (group by household)
Hope that helps, let me know if you have any questions.
Angelos