I want to understand what KNIME nodes can I use to perform VLOOKUP function on multiple columns.
I have two data sets, the first table has a column with IDs, and the second data set has 5 columns with similar IDs.
I need to look for the ID from first table in the second table across all 5 columns,
a. If found, exclude those rows from the second table and display data for all other rows.
b. If not found, simply display data for all other rows.
If this only uses 3 columns but hopefully you get the idea. You could also put this into a loop with Column List Loop Start if you are unsure how many incoming columns you might have.