Filter on Numerical Range
Infoveave Data Automation — Filtering & Selection
Set a minimum. Set a maximum. Every number outside the valid range is flagged, dropped, or cleared — on every run.
Numeric outliers — sensor spikes, data entry errors, negative values in columns that should always be positive — corrupt aggregations and mislead dashboards. Filter on Numerical Range applies a min/max boundary to any numeric column automatically inside your workflow, catching bad values before they reach reporting or machine learning steps without anyone having to manually inspect the data.
What Filter on Numerical Range does
Keep, remove, or flag rows where numeric column values fall within or outside a min/max range in your Infoveave workflow. Validates numeric inputs and removes outliers without SQL or code.
When to use Filter on Numerical Range
- You need to validate that numeric values in a column stay within an expected business range — for example, no negative order quantities
- You want to remove statistical outliers from a dataset before running aggregations or ML models
- Your source data contains sensor spikes, data entry errors, or test records with extreme values that should be excluded
- You need to flag out-of-range values for a data quality audit without removing them from the pipeline
When to avoid it
- You need to group numbers into labeled ranges rather than filter them — Numerical Binning is the right tool for that
- Your filter condition is more complex than a simple min/max — for example, filtering where one column's value exceeds another column — use Filter on Formula instead
- You are filtering on text values rather than numbers — use Filter on Values for that
Where it fits in your Infoveave automation
Filter on Numerical Range 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 Filter on Numerical Range
Real scenarios where this transformation saves hours of manual work.
Remove Sensor Spike Readings from OEE Data
A factory's IoT pipeline occasionally receives temperature readings that are physically impossible — values far above or below the operational range. Filter on Numerical Range removes those spikes automatically before the OEE aggregation runs, keeping the dashboard clean without manual inspection.
Validate Patient Vital Signs Before Analysis
A health analytics team validates that heart rate readings fall within physiologically possible bounds before feeding data to trend analysis. The workflow flags and removes out-of-range values automatically on each patient data import, preventing corrupted readings from distorting population health reports.
Exclude Negative Order Values from Revenue Reports
A finance team's transaction export occasionally includes negative order amounts from credit note entries that should not be counted as revenue. Filter on Numerical Range removes values below zero from the revenue column before the monthly P&L aggregation runs — automatically, on every import.
See Filter on Numerical Range in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
Value1050Keep Matching RowsInput Data
| Value | Description |
|---|---|
| 5 | data1 |
| 10 | data2 |
| 25 | data3 |
| 50 | data4 |
| 75 | data5 |
Output Data
| Value | Description |
|---|---|
| 10 | data2 |
| 25 | data3 |
| 50 | data4 |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Columns
Select one or more numeric columns to evaluate. When multiple columns are selected, the flag or action applies based on whether any or all columns match the range — controlled by the FlagRows Action setting.
Minimum / Maximum Value
Both boundaries are inclusive. Set both for a bounded range, or only one for an open-ended filter — for example, set only the minimum to exclude anything below zero.
Actions
Five options: Keep Matching Rows retains rows within the range. Remove Matching Rows drops them (use for outlier removal). Flag Rows adds a 0/1 indicator without removing rows. Clear Content of Matching Cells or Non-Matching Cells nullifies specific numeric values while keeping the row structure intact.
Flag Rows Action
When Flag Rows is selected and multiple columns are evaluated: Flag if Any Column Matches triggers the flag when at least one column falls in range. Flag if All Columns Match triggers only when every selected column satisfies the range condition.
Frequently asked questions
Everything you need to know about Filter on Numerical Range in Infoveave.
Also in Filtering & Selection — and what runs before & after
Transformations in the same family as Filter on Numerical Range, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Filter on Numerical Range 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?
