I want to join these 2 tables based on the country. In Excel I would VLookup the other columns based on the Country column. In KNIME, I’ve tried using Joiner but I am getting almost 800.000 rows when in reality it should be the same number of rows as in Table A.
In a Joiner you most likely want to choose a column (or columns) which make a row unique in a table. If you join on non-unique columns you get an exponentially growing result-table.
If a value of Country appears 10x in table A and 40x in table B this will give you 400 rows in the result.
If possible you can use a GroupBy node to make a table with unique rows for a Country, before the join is made.