Select
Remove multiple columns in your data using the Select tool.
Keep only specified columns in your data by removing multiple columns in your data.
When to use this tool
Use when you want to remove a lot of columns.
If you want to remove only a few columns, use the Drop tool.
Input
The Select tool requires one data input.
Configuration
Use the following configuration options to help create your Select configuration.
In Pipe builder, add your data source.
Click +Add Tool.
Click See all tools.
In the search bar, search for Select. Click Add tool.
Tip
You can also find the Select tool in the Clean section.
Connect the tool to your data set.
In the configuration pane, enter the following information:
Table 47. Select tool configurationField
Description
Columns to select
Select the column(s) to keep in your data.