What does the Copy Column Transformation do?
The Copy Column Transformation simply takes an input column and creates a duplicate of it with a new name. It’s pretty easy to configure, as shown below:
You just select the input column and name the created Output column. You can duplicate an individual column as many times as you want.
When would you use the Copy Column Transformation?
Whenever you need to create multiple copies of an input column. However – like the Audit Transformation – this could just as easily be done in a Derived Column transformation, which gives you much more flexibility. So the BI Monkey advises largely ignoring this Transformation.