The process step Column Reorder does exactly what its name says. It solves a common problem when the source data has a different structure than the target data. In this simple step you can reorder the columns avoiding long and tedious copying and pasting column-by-column.
There are four parameters that are required to be filled when using this process step:
The columns are copied from source to target worksheet in the order they are specified within the Source columns and Target columns parameters, to the same positions. If there is a B column specified on the third position (A;C;B) in the Source columns parameter, and the C column is specified on the third position (A;B;C) in the Target columns parameter, the B column from the source worksheet will be copied to the C column in the target worksheet.
1 | 2 | 3 |
A | C | B |
A | B | C |
Example: Take the columns A, C and D from the source worksheet and copy source column A to target column D; source C to target A; and source D to target C.