Conditional merging of Shapefiles

[MoritzWollen]

Hi everyone,

i try to merge a set of shapefiles under certain conditions. There are two attributes for the geometries in my files - "Type" and "Score".

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.

Is there a way to define advanced merge conditions?

Thank you.

[JoshuaBixby]

Several of the merge rules only apply to fields if they are numeric.  What data type is "Type"?  If text, how are you determining the highest value?

[MoritzWollen]

The data type of "Type" is text. The data type of "Score" is float. I calculate the highest value exclusively from the Score.

In summary, I try to remove duplicates (same geometry). I want to keep the geometry with the attributes that have the highest Score.