Skip to main content

Varicent ELT Help Center

Select

Abstract

Remove multiple columns in your data using the Select tool.

Use the Select tool to keep only the columns you need for further analysis and reporting. Only columns you select to keep remain in the data set. All other columns are dropped.

Tip

The Select Tool is ideal if you're looking to remove a lot of columns. Think of it this way, if you're keeping fewer columns than you're dropping, use the Select tool. If you only want to remove a few columns, the Drop tool is a better fit.

Input

The Select tool requires one data input.

Configuration

Use the following configuration options to help create your Select configuration.

Configuring the Select tool

  1. In , add your data source.

  2. Click symon_add_icon.png +Tool.

  3. In the search bar, search for Select. Click + Add tool.

    Tip

    You can also find the Select tool in the Clean section.

  4. Connect the tool to your data set.

  5. In the configuration pane, enter the following information:

    Table 52. Select tool configuration

    Field

    Description

    Columns to select

    Select the column(s) to keep in your data.