Icon

Rule engine in loop test

The goal is to replace all NULL entries in a column with a KNIME missing value (?)This can easily be achieved using rule engine which identifies any cells that DO NOT containthe word NULL and returning the original value, but doesn't return a value if the cell contains thekeyworkd (NULL).However, this doesn't work in a column list loop. The Rule Engine doesn't recognise thevariable as a colum name and treats it as a string, rendering the incorrect output. Create tableof test dataReplace NULLIn column 2Loopoverall columnsReplaceNULL in selectedcolumnEnd loop Table Creator Rule Engine Column ListLoop Start Rule Engine Loop End (ColumnAppend) The goal is to replace all NULL entries in a column with a KNIME missing value (?)This can easily be achieved using rule engine which identifies any cells that DO NOT containthe word NULL and returning the original value, but doesn't return a value if the cell contains thekeyworkd (NULL).However, this doesn't work in a column list loop. The Rule Engine doesn't recognise thevariable as a colum name and treats it as a string, rendering the incorrect output. Create tableof test dataReplace NULLIn column 2Loopoverall columnsReplaceNULL in selectedcolumnEnd loop Table Creator Rule Engine Column ListLoop Start Rule Engine Loop End (ColumnAppend)

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: DavidPlummer
Created at: 2021-03-17
On NodePit since: 2021-03-17
Last update: 2024-05-02
Created with KNIME version: v4.3.2

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

Try NodePit Runner!