update db (cleaning data)

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