Data Cleaning Exercises

Pro exercise

Stack files without losing identical rows

Two branches send sales files with no row IDs. A sale of the same SKU and quantity on the same day in both branches appears as identical rows, and both are real. Stack the files and total units per SKU without collapsing them.

  • combining files
  • UNION ALL
  • aggregation

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