How to use the Spreadsheet Duplicate Row Finder.
Define duplicates by the fields that establish record identity. Keep original row references and do not merge conflicting values silently.
Make the workflow fit your task.
Choose the columns that define a duplicate and whether case or surrounding spaces count. Group matching records with their original row numbers. Distinguish identical copies from records sharing a key but disagreeing elsewhere, and keep conflicts available for review.
- What you provide
- Supplied table and matching keys.
- What you get
- Duplicate groups preserving original row references.
See the input and the result.
Illustrative input and output · a teaching example, not a live WebAct run
Example input
Compare exact order_id values. Source rows: row 2: O12, USD 100; row 3: O13, USD 50; row 4: O12, USD 105. Keep source references.
Completed example
Duplicate-key group O12: - Row 2: USD 100 - Row 4: USD 105 Classification: conflicting amounts, difference USD 5. Row 3 has no duplicate key in this input. No rows removed; an owner must resolve the conflict.
Load this input into the prompt, then copy it to WebAct to try the task. Your result may differ from the illustration.
Decisions and troubleshooting.
Should repeated customer names count as duplicate records?
Names alone rarely establish identity. Use the appropriate record key and supporting fields for the dataset.
Why did removing duplicate IDs lose a newer value?
The rows may have represented conflicting updates. Review timestamps and field differences before deciding which record, if any, to retain.
Try it with your own source.
Replace the example with your material in the task prompt. Keep the requirements you need, then copy the task into WebAct.
Customize and copy the task ↑