Drop Columns

Removes one or more specified columns from the table.

Example

name	gender	city
John	male	London
Jane	female	Paris

→

name	city
John	London
Jane	Paris

Configuration

The following option(s) are available when configuring this transform.

Column

Select one or more columns to be removed from the table.

Screen shot of drop transform configuration

Adding the Transform

Select one or more columns by clicking on any column header in the table.
Find Drop transform under Column Manipulation group.

Alternatively, you can click on + Add Script Step on the right of the Wrangler to find Drop transform under Column Manipulation group.

Screen recording of adding the drop transform

Delete Edit Text