Filtering List by Nearest Point to 1 of 2 Destinations

[ijurgensen]

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!

[Luke_C]

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. 

[AngelosPachis · Accepted solution]

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