Column Reorder

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:

  • Source worksheet Djeeni name: The Djeeni name of the source worksheet (the worksheet we want to copy the columns from)
  • Source columns: Column letters referring to the source worksheet, separated by semicolon character (A;C;B)
  • Target worksheet Djeeni name: The Djeeni name of the target worksheet (the worksheet we want to paste the columns to)
  • Target columns: Column letters referring to the target worksheet, separated by semicolon character (A;B;C)

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.