GreaterThanEqualToColumn / Boolean Layer
Create boolean mask columns by comparing if values in one column are greater than or equal to corresponding values in another column. Similar to pandas df['A'] >= df['B'] or R's element-wise comparison.
Common applications:
- Target achievement verification
- Minimum requirement checking
- Performance benchmarking
- Quality thresholds
- Compliance monitoring
Example:
Index | Actual | Target | Greater Equal |
---|---|---|---|
0 | 100 | 90 | true |
1 | 75 | 75 | true |
2 | null | 80 | null |
3 | 60 | 70 | false |
4 | 85 | null | null |
Compare
[, ...]List of greater-than-or-equal comparisons to perform. Each creates a new boolean column. Common scenarios:
- Goal achievement monitoring
- Compliance verification
- Performance evaluation
- Quality assurance checks
At least one comparison must be specified.
SelectLeft
columnThe column to compare (left side). Must contain ordered values (numeric, datetime, etc.). Null values result in null in the output mask. Common uses:
- Achieved values
- Actual measurements
- Observed results
Forms the left side of the comparison operation.
SelectRight
columnThe column to compare against (right side). Must be comparable with SelectLeft
. Null values result in null in the output mask. Common uses:
- Target values
- Minimum thresholds
- Required levels
Forms the right side of the comparison operation.
AsColumn
nameName 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.