HANDLING DUPLICATES

The AutoCleaner notify when it detects duplicates in the data set

You are unable to run the AutoCleaner if there are duplicates in the data set

To remove the duplicates, use the Merge Duplicates tool included with Ablebits.

Click Next at the first screen of the pop-up window

Select the following criterion to find duplicates:

• Lastname

• Firstname

• Grade

• Student_ID 

Check that your table has 1 header row

This final screen will let us dictate what values from the duplicates we are trying to collect. In the vast majority of cases we want their email. 

Selecting “Email1” means that duplicate records with an Email1 will have that data stored in the “Email1” field of the merged record.

Check the box to delete duplicate values

Upon a successful Merge Duplicates, a message like this will appear. It will show you the number of records that have been combined if there were any.

Once we have moved past this pop-up we are ready to run the AutoCleaner!