1. Create a new Constituent query
  2. On the Criteria tab, select the following: 
    Aliases > Alias Type [not blank]
    AND Aliases > Alias [blank]
  3. On the Output tab, select the following:
    Constituent Information, Name
  4. Click Run Now or select the Results tab to go to the results
  5. Open the first records that appear in the results
  6. On the Bio 1 (or Org 1) tab, click the Alias button
  7. Delete any rows in which the Alias type is populated, but the Alias field is blank
  8. Save and Close the constituent record
  9. Repeat for all records listed in the query
  10. Run the Duplicate Constituents Report again
Repeat the previous steps for the following queries: 
  • Relationship query filtering on: 
    ( Individuals > Aliases > Alias Type [not blank]
    AND Individuals > Aliases > Alias [blank] )
    OR (Organizations > Aliases > Alias Type [not blank]
    AND Organizations > Aliases > Alias [blank] ) 
     
  • Participant query with this criteria: 
    Participant Information > Name Fields > Aliases > Alias Type [not blank]
    AND Participant Information > Name Fields > Aliases > Alias [blank] 
     
  • Constituent query filtering on: 
    (Constituent Information, LastName is Blank 
    AND Key Indicator equals Individual) 
    OR (Organization Name is Blank 
    AND Key Indicator equals Organization)
OR
  1. Go to Config > Business Rules > Duplicates
  2. Unmark the Alias checkboxes for 'Check for Individuals' and 'Check for Organizations'
  3. Run the Duplicate Constituents Report again