Move Transform

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.

Parameters

move col:column_ref before:column_ref | after:column_ref

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

TokenRequired?Transform BuilderData TypeDescription
moveYMove columnstransformName of the transform
colYColumnstringName of column or columns to move
afterbefore or after is required.AfterstringName of column after which to place the moved columns
beforebefore or after is required.BeforestringName 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.
  • Where applicable, a range of values can be specified using a tilde (~).

Usage Notes:

Required?Data Type
YesString (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 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.

The column before which the object of the transform is to be placed.

Usage Notes:

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

Examples

Example - Reorder Columns

Source:

CBA
741
852
963

Transform:

move col:A before:C

move col:C after:B

Results:

ABC
147
258
369

Was this page helpful? Let us know how we did:

Send feedback about...

Google Cloud Dataprep Documentation