Data Cleaning Exercises

Pro exercise

Deduplicate order lines at the right grain

An order has several lines and each line has versions. Keep the latest version of every line, not one row per order.

  • deduplication
  • row grain
  • type conversion

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