Moves the specified column or columns before or after another column in your dataset. 

move col: FirstName before: LastName

Output: The column FirstName is moved before the column LastName.

move col:column_ref before:column_ref | after:column_ref

NOTE: At least one of the after or before parameters must be included.

TokenRequired?Data TypeDescription
moveYtransformName of the transform
colYstringName of column or columns to move
afterbefore or after is required.stringName of column after which to place the moved columns
beforebefore or after is required.stringName of column before which to place the moved columns

col

Identifies the column or columns to which to apply the transform. You can specify one or more columns.

 

Required?Data Type
YesString (column name)

after

move col: ZipCode after: State

Output: Moves column ZipCode so that it appears after the column State

Required?Data Type
Either after or before is required. Do not include both.Column reference

before

move col: ItemName before: ItemColor

Output: Moves the column ItemName so that it appears before the ItemColor column in your dataset. 

Required?Data Type
Either  after  or  before  is required. Do not include both.Column reference


Example - Reorder Columns

Source:

CBA
741
852
963

Transformation:

Results:

ABC
147
258
369

Example - Move multiple columns

The following examples illustrate how you can move multiple columns in a single transformation.

Source:

ABCDEF
123456
789101112
131415161718
192021222324

Transformation:

Results:

DBFEAC
426513
108121179
161418171315
222024231921