replacing cell values if they are available in anoher table

[sands]

Hey all,

Is there a way for replacing cell values in collumn A only if the values in collumn B match with another table, this other table also holds the new/replacement values.

Thanks in advance for your reply!

[knimediger]

Hello @sands ,

Welcome to the world of KNIME.
You might give the Join-node a try using an inner Join to your primary table.
After that you have all data records with both values.

[sands]

Hey knimediger, thanks for your reply! Unfornately its not producing my desired result so i altered my question so you brought me 1 step foreward

[sands]

@sands

new

Hey all,

Is there a way for replacing cell values in collumn A only if the values in collumn B match with another table, this other table also holds the new/replacement values.

So I pursue that there is no collumn added and no rows are being filtered out in my orginal table. If a row has no match in the other table collumn A still holds the old value. If there is a match (via collumn B) the new value is displayed in collumn A.

Thanks in advance for your reply!

[ArjenEX]

You will temporarily have additional columns but you can just filter those out later on. Like @knimediger mentioned, do a left outer join from column B to that external table and retrieve the replacement value. For rows where that is not null, replace column A with that new value. Can be done for example with a Column Expression, Java Snippet, etc.

Tip: try to include some visual reference like input files, desired output example, screenshots, attach your workflow etc. It allows other users helping you more efficiently.

[sands]

Thanks! in addition of all your answers i used the node Column Merger, works like a charm!