When you're not quite sure why your transformation is not happening the way you want, it is important to understand in what order they are being executed.
Transformations are executed in this order:
Column matches
This includes all matches or links that you do, by matching the input columns with the target template
In the case of "valid values", column matches will copy all the input columns values into the target template column requiring values.
Rules
All rules are then executed
Corrections, including value corrections
All corrections happening in the Finalize step are applied, from the Solutions panel.
Value corrections are those applying to columns accepting lists of valid values
Quick fixes
Those are "manual" corrections that you do when editing directly in the table at the finalize step
Template rules
Those are rules established at the template level.
This order means that :
If you make a manual correction in the table at the Finalize step, you can only remove it manually, or by a template rule.
If your corrections introduce bad content at the Finalize step, you can only remove them by undoing the correction. Doing a rule on a correction will have no effect.
Example of a quick fix: they're indicated by the
symbol
Example of a previous correction in the Solution panel, you can just undo it by clicking the
link

