topic Arcade expression to select the maximum value from identical IDs and assign the related attribute data. in ArcGIS Online Questions https://community.esri.com/t5/arcgis-online-questions/arcade-expression-to-select-the-maximum-value-from/m-p/1338657#M55115 <P>I have a feature where I have three main fields of interest: ID, Group Name, and Area</P><P>Each ID field has different group names associated with it, and each having a different area. I want to calculate a field using arcade to return the Group Name for the ID with the maximum area. I posted a picture below demonstrating what the table looks like. I've tried a few different things, with no success, and looking for some guidance. Kind of a newbie to coding in arcade.</P><P>huc12 is the ID</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2023-10-17 093652.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/83240i5862FAAAEF9A1028/image-size/medium?v=v2&amp;px=400" role="button" title="Screenshot 2023-10-17 093652.png" alt="Screenshot 2023-10-17 093652.png" /></span></P> Tue, 17 Oct 2023 15:39:17 GMT BrennonPeterson 2023-10-17T15:39:17Z Arcade expression to select the maximum value from identical IDs and assign the related attribute data. https://community.esri.com/t5/arcgis-online-questions/arcade-expression-to-select-the-maximum-value-from/m-p/1338657#M55115 <P>I have a feature where I have three main fields of interest: ID, Group Name, and Area</P><P>Each ID field has different group names associated with it, and each having a different area. I want to calculate a field using arcade to return the Group Name for the ID with the maximum area. I posted a picture below demonstrating what the table looks like. I've tried a few different things, with no success, and looking for some guidance. Kind of a newbie to coding in arcade.</P><P>huc12 is the ID</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2023-10-17 093652.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/83240i5862FAAAEF9A1028/image-size/medium?v=v2&amp;px=400" role="button" title="Screenshot 2023-10-17 093652.png" alt="Screenshot 2023-10-17 093652.png" /></span></P> Tue, 17 Oct 2023 15:39:17 GMT https://community.esri.com/t5/arcgis-online-questions/arcade-expression-to-select-the-maximum-value-from/m-p/1338657#M55115 BrennonPeterson 2023-10-17T15:39:17Z