3 tables and one of them have connective key

KNIME Analytics Platform
#1

Hi :slight_smile: I have 3 tables and one of them have connective key(which connect 1,2 tables)
e.g.

table 1:
Column_name
1
2
3

table 2:
Column_name
45
67
49

table 3:
column_name_1 column_name_2
1 67
2 45
3 49

Is there any option to join table 1 and table 2 with this connection key in table 3 ?

#2

Hi,
That is possible using two joiner nodes. First join table 1 to table 3, then the result to table 2.
Kind regards,
Alexander

1 Like
#3

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.