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 14:36] andraz |
en:process_steps:range_cell:columnreorder [2024/02/24 23:38] (current) tiger |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | {{indexmenu_n> | ||
| ====== Column Reorder ====== | ====== Column Reorder ====== | ||
| Line 5: | Line 6: | ||
| There are four parameters that are required to be filled when using this process step: | 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 worksheet Djeeni name**: The Djeeni name of the source worksheet (the worksheet we want to copy the columns from) | ||
| - | * **Source columns**: Column letters | + | * **Source columns**: Column letters |
| - | * **Target worksheet Djeeni name**: The Djeeni name of the source | + | * **Target worksheet Djeeni name**: The Djeeni name of the target |
| - | * **Target columns**: Column letters separated by semicolon character (A;C;B) | + | * **Target columns**: Column letters |
| - | {{djeeni:column_reorder.png}} | + | 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: | ||