Skip to main content

Varicent ELT Help Center

Remove Outliers

Abstract

Remove records outside of the range that you specify.

Use the Remove Outliers tool when you want to clean your data so it doesn't contain any extreme values that could affect your analysis. For numeric columns, this tool removes records outside of a range you specify.

Input

The Remove Outliers tool requires one data input.

Configuration

Use the following configuration options to configure the Remove Outliers tool.

Configuring the Remove Outliers 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 at least one data source to your pipe. For more information on adding a data source, see the Data tool.

  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 Remove Outliers, then click + Add Tool.

    Tip

    You can also find the Remove Outliers 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, enter the following information:

    Table 57. Remove Outliers tool configuration

    Field

    Description

    Select column

    Select the numerical column to use to remove any extreme values.

    Minimum

    Enter the minimum value to use for your analysis, or click the up arrow to increase the value.

    Maximum

    Enter the maximum value for your analysis, or click the down arrow to decrease the value.