Data Cleaning Exercises

Pro exercise

Map legacy codes with a crosswalk

Old category codes are retired. Translate them with the approved crosswalk table, keep the original code next to the new category so the mapping can be audited, and report missing and unmapped codes separately.

  • mappings
  • lookups
  • traceability

Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.