
K/05Data that flows
Data intake quality checks
Catch invalid rows, inconsistent formats and duplicates before they reach a tool.
The need
Controlled intake and a report the file owner can act on.
A file can open perfectly and still contain unusable values. We define your business rules and make each rejected row explainable without asking staff to reread the whole file.
Starting scope
What the work covers.
- 01
Verifiable rules
List accepted formats, values and authoritative fields for a defined source.
- 02
Dry-run preview
Run checks before importing and expose anomalies without writing to production.
- 03
Rejection report
Report rejection reasons and hand over retry instructions using a test sample.
| Row | Check | Decision |
|---|---|---|
| 018 | Fields complete | Ready |
| 019 | Missing ID | Held |
| 020 | Duplicate found | Review |
In practice
- 01ReadIdentify columns
- 02ValidateApply agreed rules
- 03SeparateExplain rejected rows
Practical brief
How we deliver.
Validation separates format errors from business rules: a readable value can still fall outside the agreed scope. A dry run produces a report before modifying data. Issues retain their row number and reason so owners can correct only what blocks the import.
What to prepare
- An anonymised sample with valid rows and realistic errors.
- Reference rules: allowed formats, unique keys and mandatory fields.
What you receive
- A testable ruleset and a check that does not write to production.
- An actionable report with failure reasons and retry instructions.
Run the same sample twice in dry-run mode and check that errors remain consistent. Correct a rejected row and confirm it can be rechecked without affecting the rest of the file.
Good questions
To agree in the quote
The starting scope covers one format and an agreed ruleset. Automatic correction is not assumed.
What happens to an invalid row?
Set it aside with a reason. Depending on your needs, import the rest or block the batch; we agree the rule before implementation.
Are values fixed automatically?
Not by default. A correction is implemented only if the rule is documented and the change is visible or reversible.
K/05 / Data
Let’s talk about your context.
This service is preselected in the enquiry form. The first conversation defines the need; it doesn’t place an order.