Drop
Remove columns from your data with the Drop tool.
Remove columns from your data.
When to use this tool
If you don't need a column, you can remove it.
If you want to remove most columns from your data set, use the Select tool.
Configuration
Use the following configuration options to configure the Drop tool.
In your pipe, add your data source.
On the canvas toolbar, click
+ Tool
In the Tools modal, search for the Drop tool in the search bar.
Tip
You can also find the Drop tool in the Clean section.
Connect the tool to your data set.
In the configuration pane, enter the following information:
Table 48. Drop tool configurationField
Descriptions
Select columns to drop
Select the columns to drop from the drop-down menu.
The columns will be dropped from your data.
Usage example
We start with this data set:
ColumnA | ColumnB |
---|---|
A | AA |
B | BB |
In the Columns to drop field, select or type ColumnA
.
As a result, the data set now looks like this:
ColumnB |
---|
AA |
BB |