The lookup transformation is great to do mapping of surrogate keys.
I would like to have the choice of the target column I update instead of only having “Append” or “Replace in Data”.
This way the remapping of a hierarchy would be done in one step.
Currently I have to
Append new column
modify column value with expression
suppress the appended new column