Question

same Id and different distance


Badge +4

Hello Experts,

I have a file in which I have 2 columns id and distance. The distance corresponds to the ids. The issue is that some ids are duplicates and the distance is different. I want to identify the ID which has closet distance associated. See the image attached. Any help would be appreciated.

image


2 replies

Userlevel 3
Badge +33

The StatisticsCalculator can help you here.

Group by id (or NEAR_FID), calculate the minimum value of the distance (or NEAR_DIST).

The Summary port gives you one feature per id, with the minimum value as an attribute. The Complete port gives you all the input features, with the minimum value per id added to each feature as an attribute.

StatisticsCalculator

Badge +4

The StatisticsCalculator can help you here.

Group by id (or NEAR_FID), calculate the minimum value of the distance (or NEAR_DIST).

The Summary port gives you one feature per id, with the minimum value as an attribute. The Complete port gives you all the input features, with the minimum value per id added to each feature as an attribute.

StatisticsCalculator

Thank you very much for the help.

Reply