update db (cleaning data)

Hello? I need to add a node with this sql update
I see the update db node but I don’t know how to use in this scenario

update table
set householdsituationname = ‘Household with children’

where householdsituationname = ‘Household with children,’

thanks
Enrico

Hello @ecamerin,

and welcome to KNIME Community!

To my knowledge this is not possible with DB Update node as same column can not be both in SET and WHERE clause. However you can use DB SQL Executor node where you can write your statement and clean data. Would that work for you?

Br,
Ivan

2 Likes


thanks Ivan for your reply
It will probably work but I need to insert this task after a DB writer and the input available in this node does not allow this. There is only db connection input. So the execution would start immediately
Would be Ok if I can insert this node in the pipeline after db writer
thanks
Enrico

Hello Enrico!

you can use following node to extract database connection:

Also you could use connection from Oracle Connector node and use flow variable connection between DB Writer and DB SQL Executor but above node seems more appropriate.

In general you can search for nodes, workflows and more on KNIME Hub:

Br,
Ivan

4 Likes

Thank Ivan
Great It is what I needed
Enrico

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.