Skip to main content

Varicent ELT Help Center

Min Max Scaler

Abstract

Scale values in your data to fall between a given range.

Scale numeric columns based on a range you specify. Use the Min Max Scalar tool when you want to scale values so they fall between a given range.

If you want to scale values without giving a range, use the Standard Scaler.

Input

The Min Max Scaler tool requires one dataset.

Configuration

Use the following configuration options to configure the Min Max Scaler tool.

Configuring the Min Max Scaler 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 Min Max Scaler and then click + Add tool.

    Tip

    You can also find the Min Max Scaler tool in the Calculate 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 43. Min Max Scaler tool configuration

    Field

    Description

    Select Columns

    Select the numerical column or columns to scale values in a given range.

    Minimum

    Enter the minimum value for the range you want to view, or or click the arrows to increase or decrease the number.

    Maximum

    Enter the maximum value for the range you want to view, or or click the arrows to increase or decrease the number.



Usage example

Let's say you're designing a compensation plan for a team of salespeople. You can use the Min Max Scaler tool to standardize commission percentages within a desired range.

Suppose your company wants to ensure that all sales commissions fall between 5% and 15% of total sales. You would apply the Min Max Scaler tool to the commission data, setting the minimum and maximum bounds to 5 and 15, respectively. This percentage ensures that you reward top-performing salespeople proportionally while recalibrating lower commission rates to fall within a fair and motivating range.

This approach maintains equity among the sales team and ensures the compensation aligns with overall business goals by incentivizing higher sales performance.