I need to replace the values in one column based on the values in another column. As an example: say for certain rows I have a value 'true' in one column. I want to change these to 'false' if the value in a neighbouring column for the same row is 'Knime'.
Help much appreciated!
There are several nodes that can perform this task, one is probably the Cell Replaces which uses a kind of dictionary to replace values in one column; I'd also recommend to have a look at the Rule Engine and/or Java Snippet node.
Could you give a rule engine example for this. I tried but it replaces all the values of the other column if it doesn't match. I couldn't get the IF condition to apply.