Delete Columns

Parameters

The Delete Column(s) transformation has one required parameter:

Delete Column: The name of the columns that you want to delete. Add multiple columns to be deleted by clicking on the Add + button. Defaults to [].

To use the Delete Column(s) transformation in Mantium, follow these steps:

Click on the 'Add +' button to add a column to be deleted.
Input the name of the column that you want to delete as the Source Column.
Repeat steps 2-3 to add additional columns to be deleted.
Run the transformation by clicking the Save and Run Transforms button. The resulting dataset will have the specified columns deleted.

The video below demonstrates how to use the Delete Columns transformation in just a few seconds. If you prefer text, please continue reading.

Suppose we have a dataset with the following columns: ID, Name, Email, and Phone.

ID	Name	Email	Phone
1	John Doe	[email protected]	(555) 123-4567

We want to delete the Email column as it's not needed for our analysis.

To delete the Email column, configure the transformation as follows:

Delete Column:
  - Email

The resulting dataset would look like this:

ID	Name	Phone
1	John Doe	(555) 123-4567

Suppose we have a dataset with the following columns: ID, Name, Age, Email, Phone, and Address.

ID	Name	Age	Email	Phone	Address
1	Jane Smith	34	[email protected]	(555) 987-6543	123 Elm St, Apt 4B

We want to delete the Email and Phone columns, as they are not needed for our analysis.

To delete the Email and Phone columns, configure the transformation as follows:

Delete Column:
  - Email
  - Phone

The resulting dataset would look like this:

ID	Name	Age	Address
1	Jane Smith	34	123 Elm St, Apt 4B