I'm new to Knime. I'm thinking in term of vlookup in Excel. I have two data sets from two tables A and B. What I would like to do is return UserId from Table B when Country (Assigned To) contains the Country in Table A.
In this case I'd go with the Joiner node approach, but you can't join directly on the Country columns of the tables, because the column in Table B can contain more than one country. Instead use the Cross Joiner node to get the cartesian product of both tables.
Next you can use a String Manipulation node to check for each row, whether the value of the Country column is contained in the column Country (Assigned To). I did it with this Expression: regexMatcher($countryAssigned$, join(".*", $country$, ".*"))
Afterwards the exclude all rows with false value in the newly created column with a Row Filter node and last exclude all unnecessary columns you don't want to have in your finale table with the Column Filter node.