overwriting columns with value with column merge?

KNIME Analytics Platform
1

Dear all,

I have a table with three fields:
co_no
column1
column2

I try to execute
column1 = column2
using knime node column merge

Properties of node column merge:
primary column: column1
secondary column: column2
Option replace primary and delete secondary is activated.

When column1 is not null, replace is not executed!
But column1 should always be overwritten with column2.

Do I have to delete column1 before executing column merge?

Thanks for help!

BR,

Heinz

2

hi @Heinz

Column Merger node is designed to only replace the primary column (column1 in your case) with the secondary column (column2) if the primary column contains null values. Since column1 is not null, it is not replaced.

You can try using different nodes such as Column Expression node.

1
1748×582 10.6 KB

Regards,
Yogesh

4 Likes
3

Hi Yogesh,

Thanks for explaination; it helped a lot :slight_smile:

BR,

Heinz

4

Hey @Heinz ,
You can just mark it as solution.
Thanks

1 Like