Hi @Asghar , depending on exactly how you want to do the lookup, if you are using KNIME 5.1 and later, the new Value Lookup node may help as it allows you to lookup with wildcards, but the option has been hidden away.
Click the Show advanced settings link at the bottom of the configuration panel
This then reveals the following options.
I have no idea why the decision was made to hide what is probably the most sought-after addition to the lookup functionality!
You can see it demonstrated in this webinar video
https://www.knime.com/events/automate-away-spreadsheet-tasks-trusted-knime-community-contributor-brian-bates
(fast forward to 33 minutes for the Value Lookup, and then at around 35-36 minutes for an example of Value Lookup with wildcard.)
If that doesn’t serve your purpose, then you may be interested in my “joiner components”, demonstrated here:
and available from here:
If you have small datasets, the following may be a good fit for you:
If you have larger datasets, and are comfortable using sql-like syntax, the following is the fastest of these components:
There are some caveats, as internally they use they use an H2 database (you don’t need to do anything as that is already available to you) but it can give rise to some limitations in their use depending on your data types, but it may be of help