Skip to main content

Varicent ELT Assistant

Select

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. 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 search bar, search for Select. Click + Add tool.

    Tip

    You can also find the Select 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. In the configuration pane, under Columns to select, choose the column(s) to keep in your data.

  8. 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”.