Skip to main content

How to understand every change made to your file

"Explain" replays what happened to a selection, the "steps overview" lists and manages every step of the pipeline, and "column details" show everything that touches one column.

Written by Stéphane Jauffret

Explain replays what happened to a selection, the steps overview lists and manages every step of the pipeline, and column details show everything that touches one column. Three tools, all on the Finalize screen, to answer the same question at three levels of detail: why does my data look like this?

🔍 Explain — replay what happened to a selection

Select a zone of the table, a few rows and columns around the value that intrigues you, and click Launch explain. WeTransform replays the transformation on your selection, step type by step type: column matching, value matching, rules. At each stage you see the data as it was, with the values that changed highlighted.

💡 Explain is the fastest way to answer "why is this cell empty?" For example, a Power Function extracting the brand from a product label may leave a cell empty on purpose, and Explain shows you its reasoning: the AI detected that "ANNECY" is a model name, not a brand.

🗂️ The steps overview — the full history, and the controls

Open the Overview of your transformation steps from the Finalize screen, via the list icon next to the Rules button. It lists every step that ran on the file: matchings, value mappings, corrections, rules and Power Functions, each with its date, the number of impacted rows, and its status. Filters let you isolate transformations, insertions, deletions, or steps without impact.

This is also where you manage the pipeline:

  • Reorder a step by dragging it up or down the list

  • Disable a step to see the result without it, without losing it

  • Delete a step that no longer belongs

ℹ️ "Not executable" means the step is kept but currently has no effect: either it has been disabled, or the condition that triggers it is no longer present in the file, for example a correction for a violation that no longer occurs.

🔒 Some steps have a fixed position in the execution order and are shown with a padlock: matching steps always run first, and default rules, the ones defined at the template level, always run last and take priority over everything else. These can't be reordered or deleted from the overview.

📌 Column details — everything that touches one column

Click a column header and open see details: the panel lists only the steps that impact that column, with their status. It also shows the previous corrections applied to the column, each with an Undo link, and a shortcut to edit the constraints of the column.

🧭 Which one to use?

  • A specific value looks wrong → select it and Explain

  • You want to audit or adjust the whole pipeline → the steps overview

  • One column behaves oddly → the column's see details

👉 What to do next

Did this answer your question?