Database - Data Cleaning

In the section Database - Data Cleaning, the following functionality occurs:

1. Remove duplicate records
2. Remove blank records
3. Remove redundant / Orphan records
4. Single Field Update - All records
5. Data Field - Case Management
6. Data Field - Convert Title to Numeric
7. Data Field - Convert County to Numeric
8. Campaign - Consolidate

Contents

1 Remove Duplicate Records

• Choose the campaign.
• Choose the fields on which to base this removal of records on, from the list provided.
• The duplicate records that match the fields chosen, will now be removed from the database.
• Click Delete Duplicates.

2 Remove Blank Records

• Choose the campaign.
• Choose the fields on which to base this removal of records on, from the list provided.
• The blank records that match the fields chosen, will now be removed from the database.
• Click Delete Blanks.

3 Remove redundant / orphan records

• Choose the campaign.
• Delete the redundant / orphan records from the database.
• Newer records that have been uploaded will not be deleted.

4 Single Field Update - All records

• Choose the campaign.
• Select the fields to update the records.
• Enter the value to replace the current contents of this field in the text box provided.
• Update all records in this campaign.

5 Data Field - Case Management

• Choose the campaign.
• Select the fields to include.
• Reformat the fields that have been selected for this campaign by clicking on the Reformat fields button.

6 Data Field - Convert Title to Numeric

• Choose the campaign.
• Choose the field in which to convert to numeric.
• Choose whether the fields uprecognised records will be wiped, byt choosing True or False.
• Choose whether the report generated will show on the screen if it failed.
• Click on Reformat fields.