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 the majority of columns from your data set, use the Select tool.

Tip

You can configure this tool without using the configuration menu.

In the Add tool menu, start typing the first few letters of the tool name and press tab to auto-complete. Then start typing the name of the column you want to use and press tab to auto-complete.

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