Free · Beginner · 9 lessons

Combine and reconcile data files

Free course, nothing to install. Learn Strata, Oplema's browser app for data prep, on month-end work: stack three shops' till files and work through the register, repairs, web payments and budget, explaining every row that doesn't fit, then build the month-end table. Each lab starts part-built and wrong, and you complete it.

Start the course
Who it's for
People who can build a simple flow in Strata and now have several files that must agree.
If you've finished Build a report from a CSV export, or can already place and wire blocks, read a preview and filter rows, you're ready.
You'll be able to
  • Stack files despite renamed columns
  • Remove repeated rows
  • Attach and explain unmatched rows
  • Match misspelled names
  • Unpack crammed cells and JSON
  • Reshape a wide sheet
  • Fix someone else's flow
You leave with
A month-end table for fictional Kramerica Bikes' three shops, with every gap explained and built mostly unaided.

Each lesson ends with one line for the owner and a figure to check your result against. The last lesson fixes a colleague's flow, then has you build month-end yourself. Every lab runs in its lesson page.

Course outline

Bring the files together

  1. 1Combine CSV files when a column has been renamedLab
  2. 2Remove rows that appear in two filesLab
  3. 3Find out why rows don't match in a joinLab
  4. 4Label rows from a small lookup tableLab

Untangle what the files hide

  1. 5Match misspelled names between two tablesLab
  2. 6Split packed cells into columns or rowsLab
  3. 7Extract fields from JSON and reconcile paymentsLab
  4. 8Compare a wide budget sheet to actualsLab

Fix and build month-end

  1. 9Debug a flow that runs but gives the wrong totalLab

Start with lesson 1.

Stack files with renamed columns, remove repeated rows, explain unmatched joins, match misspelled names, unpack JSON and reshape a budget.