Skip to main content

Drop Columns Transform

Drop Columns removes fields that the rest of the workflow does not need.

Basic Usage​

To drop one or more columns:

  1. Select Drop Columns from the transform menu.
  2. In the "Columns to drop" field, select the columns to remove.
  3. Select Apply.

Select columns to remove with the Drop Columns transform

Configuration Options​

Basic Options​

  • Columns to Drop: Select one or more columns to remove from the dataset.

Examples​

Example: Removing Personal Information

Input Dataset:

IDNameAgeCitySalary
1Alice30New York75000
2Bob35Los Angeles80000
3Charlie28Chicago70000

Configuration:

  • Columns to drop: Age, Salary

Result:

IDNameCity
1AliceNew York
2BobLos Angeles
3CharlieChicago
caution

Dropped columns are no longer available to downstream nodes. Before applying the transform, check that no later step needs them.

Best Practices​

  1. Drop large, unused columns early to keep the rest of the workflow smaller.
  2. Before removing identifying fields, check whether distinct rows will then look identical.
  3. If the workflow is shared or audited, note why each column was removed.