Differences

This shows you the differences between two versions of the page.

--- en:process_steps:range_cell:columnreorder [2020/02/28 18:29]
tiger created
+++ en:process_steps:range_cell:columnreorder [2024/02/24 23:38] (current)
tiger
@@ Line 1: / Line 1: @@
+{{indexmenu_n>7}}
 ====== Column Reorder ======
-The process step **Column Reorder** does exactly what its name says. It solves a common problem that the source data has a different structure than the target data. In this simple step you can reorder the columns avoiding long copypasting 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.
-<code>
+There are four parameters that are required to be filled when using this process step:
-  Column Reorder  Source: A,D,F,E,B  Target: D,B,E,F,A
+  * **Source worksheet Djeeni name**: The Djeeni name of the source worksheet (the worksheet we want to copy the columns from)
-</code>
+  * **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:process_steps:range_cell:columnreorder.png?nolink&400 |}}

User Tools

Site Tools

Differences

Page Tools