I have created SQL queries that will remove the duplicates. Here is an example of one I created:

SELECT DISTINCT t_objectproperties.Object_ID AS ‘ID’, t_object.Name, t_object.ea_guid as CLASSGUID
FROM t_object, t_objectproperties
WHERE (t_object.Object_Type=’UseCase’ AND t_object.Object_ID=t_objectproperties.Object_ID AND (
((t_objectproperties.Property)=’Objective’) AND ((t_objectproperties.Value) Is Null) OR
((t_objectproperties.Property)=’Post Conditions’) AND ((t_objectproperties.Value) Is Null) OR
((t_objectproperties.Property)=’Preconditions’) AND ((t_objectproperties.Value) Is Null) OR
((t_objectproperties.Property)=’Trigger Stimulus’) AND ((t_objectproperties.Value) Is Null)
))

Perhaps you can do something similar with your problem.

(Note, to write the more complicated SQL, I usually open the EA.eap file with MS Acess. I create the query using the design view.)