Independent practice · Spreadsheet

Remove repeated order IDs

Practice dataset

My saved work →

Your task

Keep order_id, amount, note.
Deduplicate on order_id, keeping the first record.

Pass every output check to complete this task. Suggested active time: 10 minutes. You can keep working after that.

Required output

Return exactly these columns in this order.

order_idnumber
amountnumber
notestring

Expected output: 2 rows. Row order does not affect the check.

Values, data types and the number of copies of each row must match. A missing value is distinct from zero and from an empty string.

Empty CSV cells stay empty; the letters NULL are text. Apply the task’s declared replacement rules. Formulas are evaluated before checking.

Reconciliation checks

Return exactly the named columns in the stated order.
Preserve row multiplicity, numeric types and the declared missing-value policy.

Need a next step?

Hint 1: where to start

The note is not part of the key.

Hint 2: build the method

Check the declared business key, eligibility rules and missing-value policy before editing.

Hint 3: check your work

Compare the exact output columns, row count and each value with the contract; matching a total alone is insufficient.

How your work is checked

Every output check must pass. The score shows how much matched and helps you find mistakes; completion comes from passing all checks. Active time is recorded separately.

Passing records a correct practice output on this device. It is not a professional certification.

Source materials

3 original source records.

Data dictionary

order_id text | number: Source field; apply only the changes and units stated in this task’s output contract.
amount text | number: Source field; apply only the changes and units stated in this task’s output contract.
note text | number: Source field; apply only the changes and units stated in this task’s output contract.

View source data

order_id,amount,note
1,120,first
1,120,retry
2,80,first

Your work

Active 0:00 · Paused 0s

Edit the grid or the CSV. Formulas use grid row numbers, including the header row.

Business key

Browser formula support

This practice grid supports SUM, SUMIF, COUNTIF, IF, TRIM and an exact-match LOOKUP, plus arithmetic, comparisons, cell references and single-column ranges. For example: =SUM(B2:B3).

LOOKUP here returns the first exact match, or an empty value if none exists. Native Excel LOOKUP uses different matching rules. Excel workbook features, PivotTables and its full function library require Excel.

Keep missing values explicit. Arithmetic can convert an empty reference to zero; use a replacement only when the task permits it. Circular references are rejected.

CSV answer

Import answer

Keep a handoff you can replay

Check your current answer, then download the output and its report. The report includes the source, answer and each check so you can review what passed and what needs work.

To replay your work, open this task with the same dataset, import your answer and check it again.

Show the reference answer

order_id,amount,note
1,120,first
2,80,first

Whole-row comparison misses the duplicate business key.