Skip to main content

Understanding priority of transformations

Stéphane Jauffret avatar
Written by Stéphane Jauffret
Updated over a year ago

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:

  1. 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.

  2. Rules

    • All rules are then executed

  3. 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

  4. Quick fixes

    • Those are "manual" corrections that you do when editing directly in the table at the finalize step

  5. 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

Did this answer your question?