Data Cleaning Exercises

Pro exercise

Pick the version in force on a date

The product catalog keeps every price version with a valid_from date, including versions scheduled for the future. Report the price in force on 2026-06-30: ignore future versions, then keep the latest remaining one per SKU.

  • as-of logic
  • deduplication
  • dates

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