Copying, deleting, and keeping columns

In Wrangler, you can copy, delete, and keep columns.

Copying columns

You can copy columns and add a new name to the copied column. You might want to copy a column to see the impact of using different directives on the dataset.

To copy a column, follow these steps:

1. For the column you want to copy, select the drop-down menu.

2. Select Copy column, and enter a new name for the column.

Wrangler copies the column and adds the copy directive to the recipe. When you run the data pipeline, the transformation will be applied to all values in the column.

Deleting columns

For datasets with lots of columns, delete unnecessary columns to help improve pipeline performance and save resources. The fewer columns, the faster the pipeline run completes. This is especially true for pipelines that include a Joiner transformation.

To delete a column from a dataset, follow these steps:

1. For the column you want to delete, select the drop-down menu.

2. Select Delete column.

Wrangler deletes the column and adds the drop directive to the recipe.

Keeping columns

You can keep one column in a dataset and drop the rest of the columns.

To Keep a column in a dataset, follow these steps:

1. For the column you want to keep, select the drop-down menu.

2. Select Keep column.

Wrangler deletes all columns in the dataset except the one you marked to keep and adds the keep directive to the recipe.