Data Cleaning Exercises

Pro exercise

Stack by column name, not position

Two exports have the same columns in a different order. SQL's UNION ALL matches columns by position, so SELECT * from both puts regions into the id column without any error. Stack by name, then validate.

  • union
  • schemas
  • combining files

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