Icon

toEmpty_​function_​problem

It gives missing "activity" values in cases where activity_units is missing. This should not happenbecause in the expression activity_units is wrapped by the toEmpty function! (e.g.toEmpty($activity_units$)FUNCTION:join(toEmpty($activity_type$), "", toEmpty($activity_relation$), "",toEmpty(string($activity_value$)), "", toEmpty($activity_units$)) it fails to create a single activity string cellin cases where activity_units is missing,even if the toEmpty function is usedexample dataactivity_units to nullif emptyinfact the toEmpty function doesn'tconvert missing to empty cells! String Manipulation Table Creator String Manipulation String Manipulation It gives missing "activity" values in cases where activity_units is missing. This should not happenbecause in the expression activity_units is wrapped by the toEmpty function! (e.g.toEmpty($activity_units$)FUNCTION:join(toEmpty($activity_type$), "", toEmpty($activity_relation$), "",toEmpty(string($activity_value$)), "", toEmpty($activity_units$)) it fails to create a single activity string cellin cases where activity_units is missing,even if the toEmpty function is usedexample dataactivity_units to nullif emptyinfact the toEmpty function doesn'tconvert missing to empty cells! String Manipulation Table Creator String Manipulation String Manipulation

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: giovannicincilla
Created at: 2025-07-09
On NodePit since: 2025-07-09
Last update: 2025-07-31
Created with KNIME version: v5.2.6

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

Try NodePit Runner!