Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:process_steps:range_cell:columnreorder [2020/03/12 13:56] andraz |
en:process_steps:range_cell:columnreorder [2024/02/24 23:38] (current) tiger |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | {{indexmenu_n> | ||
| ====== Column Reorder ====== | ====== 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: | + | 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. |
| - | {{djeeni:column_reorder.png}} | + | 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. | ||
| + | |||
| + | {{ :en: | ||