Data Cleaning Exercises

Pro exercise

Old orders for discontinued products

Enrich order lines with the product's price and status. A product that has since been discontinued still existed when it was ordered, so those orders stay — flagged, not rejected. Only SKUs the catalog has never heard of are errors.

  • lookups
  • flags
  • history

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