User Tools

Site Tools


Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
en:process_steps:range_cell:columnreorder [2020/03/13 09:48]
andraz
en:process_steps:range_cell:columnreorder [2024/02/24 23:38] (current)
tiger
Line 1: Line 1:
 +{{indexmenu_n>7}}
 ====== Column Reorder ====== ====== Column Reorder ======
  
Line 11: Line 12:
 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. 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 | +|  1  |  2  |  **3**  | 
-| A | C | B | +|  A  |  C  |  **B**  | 
-| A | B | C |+|  A  |  B  |  **C**  |
  
-Example: Take the columns A to G from the source worksheet and put B before A in the target worksheet. All other columns stay in the same order. +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.  
  
-{{djeeni:column_reorder.png}}+{{ :en:process_steps:range_cell:columnreorder.png?nolink&400 |}}