Icon

Converting Numbers to Missing - KNIME Forum (90879)

<p>Clean up CSV File and converting numbers to missings</p>

URL: Clean up CSV File and converting numbers to missings - KIME Forum (90879) https://forum.knime.com/t/help-needed-9999-not-converting-to-missing-values-in-knime-workflow/90879/3?u=mlauber71

Clean up CSV File and converting numbers to missings

https://forum.knime.com/t/help-needed-9999-not-converting-to-missing-values-in-knime-workflow/90879/3?u=mlauber71

Iterate over the numeric columns, rename them to a standard name and then rename them back and collect the results

INMET_CO_DF_A001_BRASILIA_01-01-2001_A_31-12-2001.CSVstart importing at line 7
CSV Reader
make surethe order is preserved
Reference Column Resorter
comma as decimal separator
String to Number
DATA
String to Date&Time
HORA
String to Date&Time
Extract Table Spec
result.table
Table Writer
if($["_x_temp"]==-9999,MISSING,$["_x_temp"])
Expression
_x_temp
Column Renamer
Column List Loop Start
exclude DATA and HORA
Column Filter
bring the rest of the columns together
Joiner
Reference Column Filter
_x_temp
Column Renamer
Loop End (Column Append)

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: A9699459
Created at: 2025-12-02
On NodePit since: 2025-12-03
Last update: 2025-12-04
Created with KNIME version: v5.8.1
Tags: csvcleanmissings

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!