---
title: Force numerical range
description: Limit numeric values to a specified range or clear outliers.
category: Data Transformation
tags: [numerical, range, clamp, clip, outlier, filter]
---

# Force numerical range

## Description

The **Force Numerical Range** activity ensures numeric values in selected columns stay within a user-defined range. This helps normalize data, reduce the impact of extreme values, and prepare datasets for further analysis or modeling.

You can either **clip** values to stay within bounds or **clear outliers** entirely based on configuration.

---

## Input

| Type | Description                               |
| ---- | ----------------------------------------- |
| Data | Dataset with numeric columns to evaluate. |

---

## Output

| Type             | Description                                                       |
| ---------------- | ----------------------------------------------------------------- |
| Transformed Data | Data with numeric values forced within range or outliers removed. |

---

## Configuration Fields

| Field Name         | Required | Description                                                                   |
| ------------------ | -------- | ----------------------------------------------------------------------------- |
| **Column Names**   | Yes      | One or more numeric columns to apply the transformation to.                   |
| **Lower Bound**    | Yes      | Minimum allowable value. Values below this will be handled accordingly.       |
| **Upper Bound**    | Yes      | Maximum allowable value. Values above this will be handled accordingly.       |
| **Clear Outliers** | No       | If enabled, removes rows with values outside bounds. Otherwise, clips values. |

> When **Clear Outliers** is enabled, **any row** containing a value outside the range in **any selected column** is removed.

---

## Behavior Summary

| Clear Outliers | Action                                                   |
| -------------- | -------------------------------------------------------- |
| Disabled       | Out-of-range values are replaced with the closest bound. |
| Enabled        | Entire rows with any out-of-range value are removed.     |

---

## Sample Input

| Product | Sales  | Revenue |
| ------- | ------ | ------- |
| A       | 500    | 1000    |
| B       | 120000 | 150000  |
| C       | 75000  | 75000   |
| D       | 900    | 5000    |

---

## Sample Configuration

| **Field**          | **Value**      |
| ------------------ | -------------- |
| **Column Names**   | Sales, Revenue |
| **Lower Bound**    | 500            |
| **Upper Bound**    | 100000         |
| **Clear Outliers** | Disabled       |

<!-- ![alt text](force-numerical-range-img.png) -->

---

## Sample Output (Clear Outliers = Disabled)

| Product | Sales  | Revenue |
| ------- | ------ | ------- |
| A       | 500    | 1000    |
| B       | 100000 | 100000  |
| C       | 75000  | 75000   |
| D       | 900    | 5000    |

---

## Sample Output (Clear Outliers = Enabled)

| Product | Sales | Revenue |
| ------- | ----- | ------- |
| C       | 75000 | 75000   |

---