Overview
This guide provides a step-by-step process to identify and clean up messy data.
Step 1
Create a Segment
Recommended fields to start with: Campus, Gender, Term, Major
Choose a dropdown or radio type field to investigate
Filters setup: [data] exists AND [data] is not in [any of your values] (see picture below)
Segment result: problematic data
STEP 2
Export segment, including ElementID and the field of interest
STEP 3
Clean up data in Excel (or any other data manipulation tool) file if necessary.
TIP: Look for "Find and Replace" options in your data manipulation tool
STEP 4
Re-import carefully
Pay attention to mappings and transformations
Check the preview first!
Remember: Majors, Terms, Campuses, Sources, and Labels should appear as the GUID. Gender as name. Degrees as codes.
Import as null when necessary (to remove data from a field)