Create a table using two tables

KNIME Analytics Platform
1

Hi - I am very new to Knime and here is my requirement. I have two tables:

Table 1:
SubID,Iteration
100,0
101,0
102,1
103,1
104,1
105,2

Table 2:
Status,ActivityType,Iteration
2,2,0
3,1,1
1,3,2

Output Table:
SubID,Status,ActivityType,Iteration
100,2,2,0
101,2,2,0
102,3,1,1
103,3,1,1
104,3,1,1
105,1,3,2

Can anyone help me out here?

Thanks and Regards
Rahul

2

Use the Joiner node with the joining column set to Iteration for both tables.
best,
Gabriel

3

Thanks gab1one. It worked.:slight_smile:
Regards
Rahul