Hi @Steve_Bunde. Welcome to the KNIME Community.
It would be easier to help if we could see an uploaded a simple example of your data as then things like column names would be clearer but going on what you have described, that there is a single common column containing a date in Mon dd format, hopefully this example will make it clear.
You can use a joiner node to join the two tables:
The join settings would be this:
I would suggest in my example above ticking “left unmatched rows” so that if a date isn’t present you would still have the “user record” but with a missing value for the dayname.
In the column settings you would select only the dayname to be included from the “right” table (bottom table attached to the Joiner), so as not to other column(s).
If you are using KNIME 5.x and do not see the “joiner node”, make sure you have KNIME set to show all nodes rather than just “starter nodes”
As you are looking up details using a single column value, an alternative to this, in KNIME 5.x, is the Value Lookup node
