Filtering List by Nearest Point to 1 of 2 Destinations

Question

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

DestinationHouseholdDistanceAGandalf3BGandalf5AFrodo7BFrodo6ASam14BSam23ASauron65BSauron73

Desired Workflow Output

DestinationHouseholdDistanceAGandalf3BFrodo6ASam14ASauron65

Thank you!

AngelosPachis · Accepted Answer

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