Doing a vlookup in a new column on a single table

[Startide]

Ok I asked chatgpt and google about that one, and I can’t quite grasp my head around the results I found so I figured I should ask here :

I am trying to do a vlookup in a new column, to search for the element from the line I am currently in, in another column (and return data for a third column).

Baiscally I am searching for a user ID inside a column named UID, and if that matches I want to return the content of a third column.

Hopefully that make sense.

How do I achieve this in knime ? My workflow in excel is super annoying so automating it with knime would be a big big relief

Thanks in advance

[rfeigel]

Have you tried the Value Lookup node?

[Startide]

I looked into it but couldn’t get it to work at first. Since you confirmed this was the right node to use I checked more tutorials and got it working.

Thanks a lot rfeigel !! <3