I have a set of data that contains on each row a highway, start_mp. I want to find, for each highway, the min(start_mp) and the max_start_mp and combine them into a single row of data ordered like: HWY, MIN(START_MP), MAX(START_MP), other attributes.
Page 1 / 1
You can do this with a StatisticsCalculator, then an AttributeManager.
In the StatisticsCalculator:
1. Set Attributes to Analyze to start_mp
2. Set a name for Minimum Attribute and Maximum Attribute
3. Then delete the default values for the rest of the Calculate Attributes
The data you want will come out of the Summary port of the StatisticsCalculator - you can connect this port to an AttributeManager to rename and remove attributes as needed.
-Courtney
You can do this with a StatisticsCalculator, then an AttributeManager.
In the StatisticsCalculator:
1. Set Attributes to Analyze to start_mp
2. Set a name for Minimum Attribute and Maximum Attribute
3. Then delete the default values for the rest of the Calculate Attributes
The data you want will come out of the Summary port of the StatisticsCalculator - you can connect this port to an AttributeManager to rename and remove attributes as needed.
-Courtney
Hi Courtney - thanks for the answer. That gets me closer. I have about 358 unique hwy groups in the load file. What i get now (and it's much closer than before) is the min mp for all of the unique hwy groups and the max mp of all the unique hwy groups. (the same measure for every hwy group). Apologies for not being clearer. These are point assets that cover a mp range of a hwy group and i need to pull the min and max mp for each highway from the load file.
You can do this with a StatisticsCalculator, then an AttributeManager.
In the StatisticsCalculator:
1. Set Attributes to Analyze to start_mp
2. Set a name for Minimum Attribute and Maximum Attribute
3. Then delete the default values for the rest of the Calculate Attributes
The data you want will come out of the Summary port of the StatisticsCalculator - you can connect this port to an AttributeManager to rename and remove attributes as needed.
-Courtney
Hi Courtney - thanks for the answer. That gets me closer. I have about 358 unique hwy groups in the load file. What i get now (and it's much closer than before) is the min mp for all of the unique hwy groups and the max mp of all the unique hwy groups. (the same measure for every hwy group). Apologies for not being clearer. These are point assets that cover a mp range of a hwy group and i need to pull the min and max mp for each highway from the load file.
I resolved my issue. Works perfectly. Thanks for the help. Jon.