A Guide for Data Clean-Up

Step-by-step guide on how to conduct clean-up data in Element451

Ardis Kadiu avatar
Written by Ardis Kadiu
Updated yesterday

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)

Did this answer your question?