Data Cleaning Exercises

Pro exercise

Highest number, not highest text

Find the highest invoice number per store. As text, 9 sorts after 10 and 0042 before 7, so the numbers must be compared as numbers after validation.

  • types
  • aggregation
  • sorting

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