DB Value to Null

Makes empty strings to null using the below transfromation:

NULLIF(TRIM("column"),'')

Options

Columns
Select String columns to apply transformation to
Value to be change to NULL
Enter the value that should be changed to NULL. Text values should be single quoted.%%00010e.g. 'text'

Input Ports

Icon
DB Data to apply transformation to

Output Ports

Icon
DB Data with applied transformation

Nodes

Extensions

Links

Download

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

Download Component
On NodePit since: 2023-03-20
Last update: 2024-11-18
Created with KNIME version: v4.7.1

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

Try NodePit Runner!