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 ?