Orphaned Records are records that do not have any related records.  This can happen during a merge process when child records are removed leaving behind orphaned parent records.


DataGroomr does not remove these orphaned records because this would assume that these records are no longer needed, which may not be true.  However, there are simple option to remove these records in Brushr:  


Here is an example of how to deal with orphaned Account records:

  1. Create a dataset in Brushr using a SOQL similar to this (for Account):  Id NOT in (SELECT AccountId from Contact)
  2. The resulting dataset will then show all your orphaned records.  You can delete records individually or using Mass Delete.
  3. You can also create a Mass Delete job to clean out these records periodically.