IfElseMixed / Logical Layer
Create a new column by mixing constant values and column values based on a condition. Similar to numpy where() with flexible value sources. Allows combination of fixed values and column references for true/false cases.
Example:
| Index | Condition | Col A | Const | Result (if Col A / 'DEFAULT') |
|---|---|---|---|---|
| 0 | true | 100 | - | 100 |
| 1 | false | - | 'DEFAULT' | DEFAULT |
| 2 | true | null | - | null |
| 3 | null | 80 | 'DEFAULT' | [*] |
| 4 | false | - | 'DEFAULT' | DEFAULT |
[*] depends on null_value handling
Common applications:
- Default value handling
- Mixed data sources
- Conditional constants
- Fallback values
- Dynamic value selection
SelectMask
columnThe boolean column used as condition mask. Determines whether to use true or false value sources for each row.
FillTrue
oneofConstTrue
stringConstant value to use when condition is true. Must be compatible with AsDatatype. Examples:
- '0' for default numeric
- 'UNKNOWN' for default text
- 'true' for boolean defaults
SelectTrue
columnColumn to select values from when condition is true. If empty, null values are used. Useful for dynamic true-case values from data.
FillFalse
oneofConstFalse
stringConstant value to use when condition is false. Must be compatible with AsDatatype. Examples:
- '-1' for error codes
- 'N/A' for missing data
- 'false' for boolean defaults
SelectFalse
columnColumn to select values from when condition is false. If empty, null values are used. Useful for dynamic false-case values from data.
NullValue
oneofIndicates that null values in any input (mask, selected columns, or constants) should propagate to the result.
ReplaceWith
stringReplace any nulls (in mask, constants, or columns) with this specific value. Provides consistent null handling across all inputs.
FillFrom
columnUse values from this column when encountering nulls in any input. Enables dynamic null replacement strategy.
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.
AsDatatype
enumSpecifies the output data type for the new column. Enables type control for the conditional results.
8-bit signed integer (-128 to 127). For small-range discrete values.
16-bit signed integer (-32,768 to 32,767). For moderate-range whole numbers.
32-bit signed integer (-2^31 to 2^31-1). Common for general integer data.
64-bit signed integer (-2^63 to 2^63-1). For large whole numbers.
8-bit unsigned integer (0 to 255). For small positive numbers.
16-bit unsigned integer (0 to 65,535). For moderate positive ranges.
32-bit unsigned integer (0 to 4,294,967,295). For larger positive numbers.
64-bit unsigned integer (0 to 2^64-1). For very large positive numbers.
32-bit floating point. For decimal numbers with moderate precision.
64-bit floating point. For high-precision decimal numbers.
Text data type. Default type for flexible value representation.
Categorical string type. For efficient storage of repeated string values.
Boolean type. For true/false results.