Fill Columns
Infoveave Data Automation — Column Operations
Choose how to handle gaps — statistical average, carry the previous value forward, or set a constant — and every run delivers a complete, null-free dataset.
Missing data breaks aggregations, skews averages, causes errors in machine learning pipelines, and produces gaps in dashboards. Fill Columns handles null and empty cells automatically inside your workflow using the fill strategy that makes sense for each column — statistical imputation (mean, median, mode) for numeric data, forward or backward carry for time-series, or a fixed constant when every empty cell should receive the same default. The result is a consistently complete dataset on every scheduled run, without manual patching before processing begins.
What Fill Columns does
Fill empty or null cells in dataset columns using statistical methods or constant values in Infoveave workflows. Prepare complete datasets for reporting, ML, and downstream processing.
Part of Infoveave Data Automation on the Unified Data Platform.
When to use Fill Columns
- You have a numeric column with sporadic missing values and want to replace gaps with the column mean, median, or mode for aggregation accuracy
- You have a time-series dataset and want to carry the previous row value forward (forward fill) or use the next row value backward (backward fill) to interpolate gaps
- A reporting or ML pipeline requires a null-free dataset and you want to enforce a default value for any column that is sometimes unpopulated
- You want to preserve the original column while also producing a filled version side-by-side for audit or comparison
When to avoid it
- Your empty cells indicate meaningful absence that downstream logic depends on — filling nulls would destroy that signal
- You want to remove rows with missing values rather than filling them — use Filter on Falsy Values to drop null rows instead
- You need to replace a specific non-null value (for example, replace 0 with a calculated value) — use a formula-based activity for that type of conditional replacement
Where it fits in your Infoveave automation
Fill Columns is one step inside a multi-step Infoveave workflow. Chain it with other activities — no code, no manual hand-offs.
Build this workflow visually in Infoveave Data Automation — drag, connect, and schedule with no infrastructure setup.
How teams use Fill Columns
Real scenarios where this transformation saves hours of manual work.
Impute Missing Patient Age for Risk Scoring
A healthcare analytics team prepares patient records for a risk stratification model that requires a complete Age column. Records from some sources arrive without patient age due to privacy-compliant data exports. Fill Columns replaces missing Age values with the column mean before the workflow feeds the model, producing a complete dataset that the scoring algorithm can process without null-handling logic in the model itself.
Forward Fill Sensor Readings Across Dropout Gaps
A plant data team processes hourly machine sensor logs where connectivity issues occasionally cause reading dropouts — leaving null values for one or two consecutive hours. Fill Columns applies a Previous (forward fill) strategy to carry the last valid reading forward across these gaps, producing a continuous time-series that OEE calculations and trend charts can use without breaks or NaN errors.
Apply Default Currency Code to Records Missing the Field
A finance team processes transaction records from a regional system that occasionally omits the Currency Code field when transactions use the default local currency. Fill Columns uses Fill Entire Column mode to apply the constant value USD to all rows in the Currency Code column — including non-empty rows — ensuring downstream FX conversion logic always has a non-null currency value to work with.
See Fill Columns in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
trueAge: Mean, Salary: Mean, Experience: PreviousfalseInput Data
| Employee ID | Age | Salary | Experience |
|---|---|---|---|
| 1 | 25 | 50000 | 5 years |
| 2 | 52000 | ||
| 3 | 30 | 7 years | |
| 4 | 55000 | 10 years |
Output Data
| Employee ID | Age | Salary | Experience |
|---|---|---|---|
| 1 | 25 | 50000 | 5 years |
| 2 | 28 | 52000 | 5 years |
| 3 | 30 | 52333 | 7 years |
| 4 | 28 | 55000 | 10 years |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Fill Empty Cells vs Fill Entire Column
Fill Empty Cells Only targets only null or empty values — non-empty cells are left untouched. Fill Entire Column (when disabled) overwrites all cells in the specified columns with a constant value regardless of whether they already contain a value. Use Fill Empty Cells when you want to patch gaps. Use Fill Entire Column when you need to enforce a uniform default value across the whole field.
Fill Methods for Empty Cells
Choose the fill strategy per column. Mean replaces nulls with the average of all non-null values. Median uses the middle value of the sorted column. Mode uses the most frequently occurring value. Previous carries the last non-null value above the gap forward. Next carries the next non-null value below the gap backward. Any of these can be applied to different columns in the same step.
Include Original
When enabled, the original column with its null values is preserved under its original name and new columns with filled values are added alongside. When disabled, the original column is updated in place. Enable Include Original to produce a before-and-after view for auditing how gaps were patched — useful when stakeholders want to verify the imputation before trusting filled values in reports.
Frequently asked questions
Everything you need to know about Fill Columns in Infoveave.
Also in Column Operations — and what runs before & after
Transformations in the same family as Fill Columns, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Fill Columns is one of over 80 transformation activities available inside Infoveave workflows. Chain transformations together — no code, no exports, no waiting for IT.
Ready to see Infoveave in action?