Skip to main content

Varicent ELT Assistant

Drop

Use the Drop tool to 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 the Pipe builder, add a data source to your pipe. For more information on adding a data source, see the Data Input tool.Data Input

  4. Click symon_add_icon.png + Tool.

    The Tools modal opens, where you can add tools, such as the  Aggregate  tool, to your pipe.

  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. Click the tool node and drag the line to the next tool to connect the tools. If you need to undo the action, click the line and then click Unlink.

  7. Connect the tool to your data set.

  8. Click the tool node and drag the line to the next tool to connect the tools. If you need to undo the action, click the line and then click Unlink.

  9. In the configuration pane, under Select columns to drop, choose the columns to drop from the drop-down menu.

  10. Click on the tool name to rename your tool node to a meaningful name. Name your tools in a way that describes the function, not the object or the data action. For example, use “Look up rate” instead of “Join to rate table”.

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