DB Empty String to Null

Makes empty strings to null using the below transfromation:

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

Options

String Columns
Select String columns to apply transformation to

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-05-02
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!