I couldn't find anyhting obvious - is there some way of doing a "vlookup" as in Excel with Knime?
The closest I came doing is to join two tables and use group by. This though needs a lot of work-arounds, as in rejoining with original table if you have a lot of other data-columns attached. Also, it works "ok" if you have a couple hundred or thousand columns. But if it is hundred thousands or millions then it is a bit of a pain (well, that many would be in excel as well, obviously, if at all possible...).
Is there a way via looping? Or some other function I haven't found yet? I am not good with java or perl, I imagine a snippet would be an alternative if you know what you are doing.