Remove duplicates with a survivor rule in Visual workspace

When to use it

Repeated records at the table's grain: re-sent rows, versions, the same customer from several systems.

How

Add step → Rows → Remove duplicates. Tick the key columns, add order columns for which row survives, and give a reason for the others.

One row per (order_id, line_id), keep first by version desc

• Convert columns to their types first so 10 sorts above 9.
• Missing key values group together; require a value first if they must not be merged.

Pitfalls

• Deduplicating at the wrong grain.
• An incomplete order that leaves ties to chance.
• Comparing numbers or timestamps as text.