FillNullWithValue / Manipulation Layer

Fill null values in a column with constants or values derived from other columns. Similar to pandas' fillna() with value parameter or R's replace(is.na(), value).

Supports multiple data types:

Strings (text replacement)
Numerics (constants or computed values)
Booleans (logical values)
Values from other columns

Common applications:

Data cleaning and standardization
Default value assignment
Missing data imputation
Dataset preparation for analysis
Cross-column value propagation

Note: The fill value's type must match the target column's type to maintain data consistency.

Table

SelectNull

column

The column containing null values to be filled. The chosen fill value must match this column's data type to maintain data integrity and prevent type conflicts.

Value

oneof

ConstString

string

String constant for text column fills. Examples:

'Unknown' for missing categories
'N/A' for unavailable data
'' (empty string) for blank entries

ConstDouble

f64

Floating-point constant for numeric fills. Common values:

0.0 for neutral values
-1.0 for sentinel values
Domain-specific defaults

ConstInt64

bool

false

64-bit signed integer constant for whole number fills. Used for:

Counter initialization
Index assignments
Categorical codes

ConstUint64

bool

false

64-bit unsigned integer constant for non-negative whole number fills. For:

Quantity defaults
Positive counters
Reference numbers

ConstBool

bool

false

Boolean constant for logical column fills. Common uses:

False for missing flags
True for default states
Binary feature completion

Reference values from another column to fill nulls. Used when replacement values should come from existing data rather than constants. Ensures data consistency and relationship preservation within the dataset.

Select

column

The source column to get fill values from. Must have the same data type as the target column. Common uses:

Previous period values
Default category assignments
Related field completions
Reference data mapping

AsColumn

name

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.