Data Cleaning Exercises

Pro exercise

Validate against the referenced record

Bookings must point to a room that exists and is open. Look each room up, use its state to validate the booking, and check the number of nights, reporting the first failing rule.

  • joins
  • validation
  • ordered rules

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