WWorkTools
DATA QUALITY · REAL WORK

Clean an ERP Export

ERP exports contain whitespace, mixed case and empty rows before analysis.

BUSINESS KEYBusiness key
COMPARE / MEASUREText fields
BEST STARTNormalize text and remove empty rows before matching.

Workflow

  1. Confirm the grain: decide what one row should represent in the final result.
  2. Profile key uniqueness and missing data before matching or aggregating.
  3. Calculate the result on a small sample and reconcile it manually.
  4. Run the full dataset, review exceptions, then export the evidence you need.
READY FOR THE REAL FILE?

Use the matching WorkTools utility

Your file stays in the browser for supported local tools.

Open tool →

What can go wrong

Most incorrect results come from the wrong key, one-to-many joins, mixed data types, hidden whitespace or aggregating at the wrong grain. Treat these checks as part of the analysis, not optional cleanup.