GreaterThanColumn / Boolean Layer
Create boolean mask columns by comparing if values in one column are strictly greater than corresponding values in another column. Similar to pandas df['A'] > df['B'] or R's element-wise comparison.
Common applications:
- Performance comparison
- Growth analysis
- Threshold validation
- Trend detection
- Differential analysis
Example:
| Index | Current | Previous | Greater Than |
|---|---|---|---|
| 0 | 100 | 90 | true |
| 1 | 75 | 75 | false |
| 2 | null | 80 | null |
| 3 | 60 | 70 | false |
| 4 | 85 | null | null |
Compare
[, ...]List of greater-than comparisons to perform. Each creates a new boolean column. Common scenarios:
- Multiple metric comparisons
- Cross-period analysis
- Performance evaluations
- Quality assessments
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:
- Current period values
- New measurements
- Actual 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:
- Previous period values
- Baseline measurements
- Expected results
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.