I'm writing a report to report on status of all backups using the Backup Save Set Status data source; I've noticed that there are instances where a client has more than one instance noted at the same time with contradictory data (ie one line will say status is started, another will say status is completed).

Is there any easy way in this situation to be able to remove duplicates?  I've done this by having two streams of data with a condition in each to find started and completed entries, then renaming the status field, merging the two streams of data then recreating the status field and populating it based on the values of the renamed status fields.  (I then have a further merge with data which does not equal started or completed in the status field to being in the rest of the data).