Force Numerical Range

Description

This activity transforms the numerical values of the selected columns based on the specified upper and lower bounds.

• If Clear Outliers is disabled
  • Values higher than the upper bound are converted to the upper bound value.
  • Values lower than the lower bound are converted to the lower bound value.
• If Clear Outliers is enabled
  • rows with Values outside the specified range (upper and lower bounds) are cleared.

Input

Data only

Output

Transformed data

Configuration Fields

• Column Names The names of the columns to apply the transformation.
• Upper Bound The highest permissible value; values above this will be adjusted or cleared based on settings.
• Lower Bound The lowest permissible value; values below this will be adjusted or cleared based on settings.
• Clear Outliers (Switch) Specifies how out-of-range values should be handled.
  • If enabled, rows with values outside the bounds are deleted .
  • If disabled, values are clipped to the bounds.

Sample Input

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

Sample Configuration

Sample Output

Product	Sales	Revenue
A	500	10000
B	120000	100000
C	75000	75000
D	900	10000

Sample Output 2 (example when clear outliners is true)

Product	Sales	Revenue
C	75000	75000