Hello everybody.I’m a fresh man here!
I’ve just started using KNIME to perform Data Mining.
During my work,I often join two or more tables by many-to-one join.
Perhaps I have not learnt well and also my poor English,but it seems to me that KNIME can only support one-to-one join.
So now I’m wondering if it is possible to make a many-to-one join using the Joiner node.
For example,here are two tables,
the table A is:
and the table B is:
after joining on A.column1=b.column1,I want the result be as below:
Can anyone tell me if it is possible,and show me how to do this?
Thanks a lot in advance for your answer !