Compare and replace values in a column
Hi Everyone,
I had a basic question regarding data manipulation in KNIME.
I need to compare and replace some values some values in a table based on specific condition.
I have a table with values :
I want to compare the columns to make a mapping and then replace the left column with the matching values in the same column. The output should look like:
Is there a node that can do this directly ? or can someone let me know the best method to do this. Thanks.