Move Columns
You can move or reorder individual columns or multiple columns through multiple methods.
Cut and Paste Columns
To move an individual column or multiple columns, perform the following:
Steps:
Select an individual column or select multiple columns. For example, select Column B and select Cut from the column menu.
Navigate to the location where you want to paste the column then select Paste > (Paste before or Paste after) from the column menu.
In the following example, you can see what happens when Column B
is moved after Column D
.
Source:
Column A | Column B | Column C | Column D |
---|---|---|---|
Cell A.1 | Cell B.1 | Cell C.1 | Cell D.1 |
Cell A. 2 | Cell B.2 | Cell C.2 | Cell D.2 |
Results:
Column A | Column C | Column D | Column B |
---|---|---|---|
Cell A.1 | Cell C.1 | Cell D.1 | Cell B.1 |
Cell A. 2 | Cell C.2 | Cell D.2 | Cell B.2 |
Move using Column Icons
Select the Column View icon in the Transformer bar to move columns in the Column Browser panel.
To move an individual column or multiple columns, perform the following:
Steps:
When you select an individual column or multiple columns, you are prompted with a set of suggestions.
Select the appropriate suggestion from the suggestion cards.
Edit or Add the steps, as required to move columns. For more information, see below examples.
Move using Transform Builder
In the Transform Builder, you can select one or more columns to move using finer-grained controls.
To move an individual column or multiple columns, perform the following:
Steps:
Enter Move columns in the Search panel of the Transform Builder.
Select an individual column or multiple columns, as required. The following options are available when specifying one or more columns in a transformation:
Multiple: Select one or more columns from the drop-down list. See below example.
Range: Specify a start column and ending column. All columns inclusive are selected. See below example.
Advanced: Specify the columns using a comma-separated list. You can combine multiple and range options under Advanced. Ranges of columns can be specified using the tilde (
~
) character. See below example.
Select the required option from the Option drop-down list.
Select the required column to move after or before the column.
Click Add. The selected columns are moved based on your inputs.
Move multiple columns
This example moves two discrete columns (Column A
and ColumnC
), before Column E
. These columns are not next to each other, so they can be specified using the Multiple column(s) option.
Source:
Column A | Column B | Column C | Column D | Column E |
---|---|---|---|---|
Cell A.1 | Cell B.1 | Cell C.1 | Cell D.1 | Cell E.1 |
Cell A. 2 | Cell B.2 | Cell C.2 | Cell D.2 | Cell E. 2 |
Transformation:
Transformation Name | |
---|---|
Parameter: Column(s) | Multiple |
Parameter: Column | A, C |
Parameter: Option | Before |
Parameter: Column | E |
Results:
Column B | Column D | Column A | Column C | Column E |
---|---|---|---|---|
Cell B.1 | Cell D.1 | Cell A.1 | Cell C.1 | Cell E.1 |
Cell B.2 | Cell D. 2 | Cell A.2 | Cell C.2 | Cell E.2 |
Move range of columns
You can move a range of columns to a specified location. For example, you can move Column A
through Column C
after Column D
.
Source:
Column A | Column B | Column C | Column D |
---|---|---|---|
Cell A.1 | Cell B.1 | Cell C.1 | Cell D.1 |
Cell A. 2 | Cell B.2 | Cell C.2 | Cell D.2 |
Transformation:
Transformation Name | |
---|---|
Parameter: Column(s) | Range |
Parameter: Column | A~C |
Parameter: Option | After |
Parameter: Column | D |
Results:
Column D | Column A | Column B | Column C |
---|---|---|---|
Cell D.1 | Cell A.1 | Cell B.1 | Cell C.1 |
Cell D. 2 | Cell A.2 | Cell B.2 | Cell C.2 |
Move set of columns
Using the Advanced option, you can move combinations of column ranges and discrete columns to a new location. In the following example, ColumnA
through ColumnC
and ColumnE
are moved after ColumnF
:
Source:
Column A | Column B | Column C | Column D | Column E | Column F |
---|---|---|---|---|---|
Cell A.1 | Cell B.1 | Cell C.1 | Cell D.1 | Cell E.1 | Cell F.1 |
Cell A. 2 | Cell B.2 | Cell C.2 | Cell D.2 | Cell E.2 | Cell F.2 |
Transformation:
In the transformation, you select the Advanced column(s) option where you can specify columns on a single line.
Dica
The tilde character (~
) can be used to specify the range of columns between two listed columns. Ranges and individual columns should be separated by a comma.
ColumnA~ColumnC,ColumnE
Transformation Name | |
---|---|
Parameter: Column(s) | Advanced |
Parameter: Column | A~C, E |
Parameter: Option | After |
Parameter: Column | F |
Results:
Column D | Column F | Column A | Column B | Column C | Column E |
---|---|---|---|---|---|
Cell D.1 | Column F.1 | Cell A.1 | Cell B.1 | Cell C.1 | Cell E.1 |
Cell D.2 | Column F.2 | Cell A.2 | Cell B.2 | Cell C.2 | Cell E.2 |
For more information, see Column Reference Syntax.
Move using Target Schema Mapping
Target schema mapping allows you to associate a target set of columns with your recipe. When you specified a target, you can often reposition your source columns with the targets by clicking in the interface. For more information, see Overview of Target Schema Mapping.