DataCareerHub
Explore learning
← Practice challengesFree companion · 15 minute suggested activity

Separate repeated exports from conflicting records

Data preparation practice · Use the messy source and independent clean control. Corrections belong in a derived output and a change log.

Learn → Try → ExplainReviewed 2026-10-15
01

Your task

R01 occurs twice. What must you check before removing a row? Describe the risk of an automatic correction.

02

Hint

Distinguish formatting fixes from changes in business meaning. Specify what evidence authorizes each correction.

Worked solution

Compare every field, document the duplicate occurrence and preserve its source row number. This fixture has an identical repeated row; a derived clean copy may retain one R01. If amounts differed, stop for a source decision instead of keeping the first.

04

What to hand over

Provide raw source fingerprint, old/new values, rule, evidence, affected row IDs and validation totals. A clean-looking table alone is insufficient.

Make the reasoning yours.

Try the activity before reading its reference. Keep your sources, commands and assumptions with your work. Companion activities are unsaved self-practice and do not award a certificate or change lesson progress.

Resume guidance and examples are for learning and preparation only. They do not guarantee interviews, a job offer or employment.

Public registration, payments and new paid enrolment remain disabled. These free resources do not grant access to protected course modules.

Learner dashboard ↗ · Ask a question ↗