Match columns' name and join

KNIME Analytics Platform
1

Hi

I need to join two tables where some columns are equal, but I don´t know which. I´ve tried to sorted the columns, but it didn´t work well. 

Any change related to columns' order change the columns' disposal and so the join don´t work. For example:


Table 1
              A    B    C    D
Row1    1    1    0    4
Row2    4    7    9    2


Table 2
               E    D    B
Row1     1    5    7
Row2    5    2    8

Is there any node that can match columns of different tables by name and join them?

Thanks

Eduardo

 

2

I assume you already tried the Joiner node.

In the Joiner node you should be able to specify B in the Joiner Setting tab.

Rosaria