topic Conditional merging of Shapefiles in Data Management Questions https://community.esri.com/t5/data-management-questions/conditional-merging-of-shapefiles/m-p/277781#M16012 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; border: 0px;">Hi everyone,</P><P style="background-color: #ffffff; border: 0px;">&nbsp;</P><P style="background-color: #ffffff; border: 0px;">i try to merge a set of shapefiles under certain conditions. There are two attributes for the geometries in my files - "Type" and "Score".</P><P style="background-color: #ffffff; border: 0px;">&nbsp;</P><P style="background-color: #ffffff; border: 0px;">All related geometries overlap completely. The attribute "Type" of overlapping geometries can be different. I want to adopt the geometry and all its attributes that has the highest score. In the field map of the merge tool I can set the merge rule for "Score" to maximum - but then the "Type" value of the associated geometry is not automatically taken over.</P><P style="background-color: #ffffff; border: 0px;">&nbsp;</P><P style="background-color: #ffffff; border: 0px;">Is there a way to define advanced merge conditions?</P><P style="background-color: #ffffff; border: 0px;">&nbsp;</P><P style="background-color: #ffffff; border: 0px;">Thank you.</P></BODY></HTML> Wed, 15 Jul 2020 12:50:02 GMT MoritzWollen 2020-07-15T12:50:02Z Conditional merging of Shapefiles https://community.esri.com/t5/data-management-questions/conditional-merging-of-shapefiles/m-p/277781#M16012 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; border: 0px;">Hi everyone,</P><P style="background-color: #ffffff; border: 0px;">&nbsp;</P><P style="background-color: #ffffff; border: 0px;">i try to merge a set of shapefiles under certain conditions. There are two attributes for the geometries in my files - "Type" and "Score".</P><P style="background-color: #ffffff; border: 0px;">&nbsp;</P><P style="background-color: #ffffff; border: 0px;">All related geometries overlap completely. The attribute "Type" of overlapping geometries can be different. I want to adopt the geometry and all its attributes that has the highest score. In the field map of the merge tool I can set the merge rule for "Score" to maximum - but then the "Type" value of the associated geometry is not automatically taken over.</P><P style="background-color: #ffffff; border: 0px;">&nbsp;</P><P style="background-color: #ffffff; border: 0px;">Is there a way to define advanced merge conditions?</P><P style="background-color: #ffffff; border: 0px;">&nbsp;</P><P style="background-color: #ffffff; border: 0px;">Thank you.</P></BODY></HTML> Wed, 15 Jul 2020 12:50:02 GMT https://community.esri.com/t5/data-management-questions/conditional-merging-of-shapefiles/m-p/277781#M16012 MoritzWollen 2020-07-15T12:50:02Z Re: Conditional merging of Shapefiles https://community.esri.com/t5/data-management-questions/conditional-merging-of-shapefiles/m-p/277782#M16013 <HTML><HEAD></HEAD><BODY><P>Several of the merge rules only apply to fields if they are numeric.&nbsp; What data type is "Type"?&nbsp; If text, how are you determining the highest value?</P></BODY></HTML> Wed, 15 Jul 2020 12:55:48 GMT https://community.esri.com/t5/data-management-questions/conditional-merging-of-shapefiles/m-p/277782#M16013 JoshuaBixby 2020-07-15T12:55:48Z Re: Conditional merging of Shapefiles https://community.esri.com/t5/data-management-questions/conditional-merging-of-shapefiles/m-p/277783#M16014 <HTML><HEAD></HEAD><BODY><P>The data type of "Type" is text. The data type of "Score" is float. I calculate the highest value exclusively from the Score.</P><P>In summary, I try to remove duplicates (same geometry). I want to keep the geometry with the attributes that have the highest Score.</P></BODY></HTML> Thu, 16 Jul 2020 09:56:11 GMT https://community.esri.com/t5/data-management-questions/conditional-merging-of-shapefiles/m-p/277783#M16014 MoritzWollen 2020-07-16T09:56:11Z