You are here:
Drop Columns Transformation
Drop unwanted columns from a batch data transform. For example, you can add a Drop Columns transformation after a Formula transformation to drop input columns used for a calculated column.
- In the Transform node, select the column in the Preview tab.
- In the Transform toolbar, click the
Drop
Columns
button (
).The dropped column appears in the Drop Columns step. - Alternatively, to keep the columns selected instead of removing them click Keep.
- To include additional columns, enter their label in the Select Columns to Drop/Keep Column.
- Click Apply to add the transformation to the Transform node.
- To view the
canvas,
click the
Collapse
button (
). - Click Save.
From this point forward, dropped columns can’t be used in transformations and nodes. They also no longer appear in Preview.
Did this article solve your issue?
Let us know so we can improve!
