You've applied a rule or a correction, but the result in Finalize doesn't look right. The most common cause: transformations are applied in a specific order, and two operations may be conflicting on the same column.
WeTransform now gives you full visibility into what's happening — and lets you fix it directly.
🔍 See exactly what's happening on a column
In Finalize, click on any column header. A panel opens on the right showing how many transformation steps impact that column. Click "See details" to open the full breakdown.
The detail view lists every step that touched this column, in order of execution:
The step type (Match, Rule, Correction, Quick fix, Template rule)
The step name — the exact match link or rule name
The number of rows impacted — how many rows were actually changed by this step
The status — Completed, Skipped, etc.
✅ Well done, your file is error free — when you see this message at the top of Finalize, all constraints are satisfied. The column detail view is still useful for understanding how your transformations stacked up.
🔀 Reorder or remove steps
From the column steps panel, you can:
Drag and drop steps to change their execution order — useful when two rules conflict and one needs to run before the other
Delete a step by clicking "Delete" next to it — removes that rule or correction from the transformation configuration
⚠️ Deleting a step is permanent for that transformation. If you delete a rule step, it removes it from the transformation configuration. If you later need it back, you'll have to recreate it in the Rules editor.
📋 The default transformation order
When no manual reordering has been done, WeTransform applies transformations in this sequence:
🔗 Column matches — raw data mapping from source to target columns
⚙️ Rules — all user-defined transformation rules, in the order they were created
✅ Corrections — solutions applied in the Finalize panel (value mappings, AI corrections, bulk fixes)
🖊️ Quick fixes — manual cell edits made directly in the table
🏷️ Template rules — rules defined at the target format level, applied last, overriding everything else
🔍 Common scenarios and how to fix them
My rule isn't doing anything
Open the column steps panel and check the "Impacted rows" count for your rule. If it shows 0, the condition may not be matching any rows, or a later step is overwriting the result. Check if a correction or quick fix runs after the rule and overwrites it.
My correction isn't sticking
Check if a template rule runs after your correction. Template rules run last and override everything. Open the steps panel — if a template rule appears after your correction, either edit the template rule or delete the conflicting step.
Two rules are conflicting
Open the column steps panel, identify the two rules, and drag the one that should run first to the top. The order you see in the panel is the order they execute.
💡 General rule of thumb: if you want a transformation to always win regardless of anything else, make it a template rule. It will always be last in the pipeline.
👉 What to do next