View Source

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.

Token	Required?	Data Type	Description
move	Y	transform	Name of the transform
col	Y	string	Name of column or columns to move
after	`before` or `after` is required.	string	Name of column after which to place the moved columns
before	`before` or `after` is required.	string	Name of column before which to place the moved columns

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

Required?	Data Type
Yes	String (column name)

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

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

Source:

Transform:

move col:A before:C

move col:C after:B

Results: