Excel VLOOKUP and IF THEN ELSE

I am using Knime to automate Excel VLOOKUP and IF condition.

My requirement is if VLOOKUP match is found in tab1 of Excel worksheet, then it should pick up tab1 and replace a column value in my target file. If the match is found in tab2, then it shoud pick up tab2 and so on.

I am using joiner node for VLOOKUP and getting proper result. When I do left outer join, my first table shows all values and second table shows ? whenever a match is not found. I want to replace values which are not ? with tab1 (where VLOOKUP match is found)…I wish to repeat this process for tab2 also.

Can anybody help ?

Thanks,

Preeti

Hi @plakdawala, and welcome to the KNIME forum!

It’s a bit difficult to provide detailed help without a concrete example, but here are some comments I hope are helpful.
As you’ve discovered, the Joiner node can work in your scenario.
However, if you’re only looking up a single value, the Cell Replacer node is simpler to use and probably a better choice. I think Cell Replacer it’s a closer match to Excel VLOOKUP functionality.
Kind regards,
Don

2 Likes