October challenge board
Dirty Data Lab™ · Challenge 09
Hard
Thursday, October 29 · 30 minutesMonth-End Data Audit
Month-end close is waiting on a transaction export with duplicates, mixed signs, inconsistent categories, a blank row and one pending transaction.
The assignment
Cleanup rules
There is one finished state. Use the rules to get the board there.
- Delete the fully blank row and normalize transaction IDs.
- Normalize dates to YYYY-MM-DD; title-case department/category; normalize status to Posted or Pending.
- Convert currency strings to signed decimals. Parentheses represent negatives.
- Remove duplicate txn_id records.
- Keep blank references blank; do not invent one.
- Sort by txn_id and calculate the net total for Posted transactions only.
Loading the puzzle board…
Loading your Lab profile…
Pass the puzzle
Send this one to a friend.
The friend link carries Dirty Data Lab™ referral attribution, so referred signups can be measured separately from newsletter and ad traffic.
Take the habit into Google Sheets
Practice here. Preflight real sheets with CTS Guard.
Clean That Sheet Guard checks the active Google Sheet for duplicates, missing data, formatting issues and other handoff problems before you share or import it.