Compare two table with different columns

KNIME Analytics Platform
1

Hi,

I've two tables from two different flows, the first has 3 columns: Main Author, Nr.of Authors, Journal;

the second one has 2 columns:  Title, Class.

In the column Journal in the first there are titles of journal in which there is the article so it can be found in more rows, in the column Title of the second table there is a list of journal; now I've to match the 2 tables by the name of the journal to obtain as result a table like 
 

Author, Nr.Author, Class 

 

I've tried with the node Concatenate changing Title in Journal, but it doesn't work because it doesn't find the class...

 

thanks,

Samuele

 

 

2

I think you are looking for the Joiner node.