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.
Solved
Row of data with hwy and mp. i want to find unique hwy min(mp) and max(mp) and create a single row.
Best answer by courtney_m
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
+12- Contributor
- Best Answer
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
+12- Contributor
courtney_m wrote:
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.
+18- Contributor
courtney_m wrote:
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
+12- Contributor
jonlibby wrote:
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.
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.