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.

1. In the Transform node, select the column in the Preview tab.
2. In the Transform toolbar, click the Drop Columns button ().
   The dropped column appears in the Drop Columns step.
3. Alternatively, to keep the columns selected instead of removing them click Keep.
4. To include additional columns, enter their label in the Select Columns to Drop/Keep Column.
5. Click Apply to add the transformation to the Transform node.
6. To view the canvas, click the Collapse button ().
7. Click Save.