Skip to main content

Varicent ELT Help Center

Drop

Abstract

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.

Figure 4. Drop tool example
Drop tool example


Configuration

Use the following configuration options to configure the Drop tool.

Configuring the Drop tool

  1. Go to the Pipes module from the side navigation bar.

  2. From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.

  3. In your pipe, add your data source.

  4. On the canvas toolbar, click symon_add_icon.png + Tool

  5. 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.

  6. Connect the tool to your data set.

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

    Table 51. Drop tool configuration

    Field

    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