IsBetweenColumns / Boolean Layer

Check if a numeric column value is between two other constant numeric values.

Table

SelectLower

column

The column providing lower bounds. Must be numeric and compatible with Select. Null values result in null in the output mask. Common uses:

Minimum tolerances
Lower control limits
Start of ranges

Select

column

The numeric column to check against the dynamic boundaries. Values outside bounds or null will result in false or null respectively in the output mask.

SelectUpper

column

The column providing upper bounds. Must be numeric and compatible with Select. Null values result in null in the output mask. Common uses:

Maximum tolerances
Upper control limits
End of ranges

Closed

enum

Both

Controls how boundary values are handled in the comparison. Affects whether values exactly matching bounds are included.

Both ~

Includes both boundary values [lower, upper]. Example: [10, 20] includes 10 and 20

Left ~

Includes lower bound but excludes upper bound [lower, upper). Example: [10, 20) includes 10 but not 20

Right ~

Excludes lower bound but includes upper bound (lower, upper]. Example: (10, 20] includes 20 but not 10

Neither ~

Excludes both boundary values (lower, upper). Example: (10, 20) excludes both 10 and 20

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.