Replace Column 1 Values based On Column 2 Values

[gft2012]

Hi I’m new to KNIME and I have problem replacing the column 1 values exactly same with column 2 Value.

An example:

Row Column1 Column2
0 AGR Pending
2 JPN In Progress
0 CHN Not Started

Expected result: I want column 1 to have the values in colum2.

Which node is suitable node to use to achieve this? How?
Thanks!

[MartinDDDD]

There are different ways to achieve this.

You can use String Manipulation Node, Column Expressions Node or Expressions Node for this.

Simply check the setting to overwrite Column1 and in the expression “box” reference Column2 and wrap it inside a string() function.

Screenshot shows how this works with String Manipulation Node. Note: I’m using version 5.3.

[gft2012]

Thanks Martin, didn’t know I can use replace only 1 parameter.