Data Cleaning Exercises

Pro exercise

Look up product names by SKU

Order lines carry SKUs in mixed case with padding. Normalize them, attach the product name from the catalog, and report unknown SKUs and bad quantities instead of dropping them.

  • joins
  • lookups
  • validation

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