Move Transform
Note
Transforms are a part of the underlying language, which is not directly accessible to users. This content is maintained for reference purposes only. For more information on the user-accessible equivalent to transforms, see Transformation Reference.
Moves the specified column or columns before or after another column in your dataset.
Basic Usage
move col: FirstName before: LastName
Output: The column FirstName is moved before the column LastName.
Syntax and Parameters
move col:column_ref before:column_ref | after:column_ref
Note
At least one of the after or before parameters must be included.
Token | Required? | Data Type | Description |
|---|---|---|---|
move | Y | transform | Name of the transform |
col | Y | string | Name of column or columns to move |
after |
| string | Name of column after which to place the moved columns |
before |
| string | Name of column before which to place the moved columns |
For more information on syntax standards, see Language Documentation Syntax Notes.
col
Identifies the column or columns to which to apply the transform. You can specify one or more columns.
To specify multiple columns:
Discrete column names are comma-separated.
Values for column names are case-sensitive.
Usage Notes:
Required? | Data Type |
|---|---|
Yes | String (column name) |
after
move col: ZipCode after: State
Output: Moves column ZipCode so that it appears after the column State.
The column after which the object of the transform is to be placed.
Usage Notes:
Required? | Data Type |
|---|---|
Either | Column reference |
before
move col: ItemName before: ItemColor
Output: Moves the column ItemName so that it appears before the ItemColor column in your dataset.
The column before which the object of the transform is to be placed.
Usage Notes:
Required? | Data Type |
|---|---|
Either | Column reference |
Examples
Tip
For additional examples, see Common Tasks.
Example - Reorder Columns
Source:
C | B | A |
|---|---|---|
7 | 4 | 1 |
8 | 5 | 2 |
9 | 6 | 3 |
Transformation:
Transformation Name |
|
|---|---|
Parameter: Column(s) | A |
Parameter: Option | Before |
Parameter: Column | C |
Transformation Name |
|
|---|---|
Parameter: Column(s) | C |
Parameter: Option | After |
Parameter: Column | B |
Results:
A | B | C |
|---|---|---|
1 | 4 | 7 |
2 | 5 | 8 |
3 | 6 | 9 |
Example - Move multiple columns
The following examples illustrate how you can move multiple columns in a single transformation.
Source:
A | B | C | D | E | F |
|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 |
7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 |
Transformation:
Transformation Name |
|
|---|---|
Parameter: Column(s) | A,B,C |
Parameter: Option | After |
Parameter: Column | E |
Transformation Name |
|
|---|---|
Parameter: Column(s) | B,F |
Parameter: Option | Before |
Parameter: Column | E |
Results:
D | B | F | E | A | C |
|---|---|---|---|---|---|
4 | 2 | 6 | 5 | 1 | 3 |
10 | 8 | 12 | 11 | 7 | 9 |
16 | 14 | 18 | 17 | 13 | 15 |
22 | 20 | 24 | 23 | 19 | 21 |