I want to use KNIME to find out relation between products.
For example, product 1 is produced by plant A, and procut 9 &procut 2 is also produced by plant A,
which means procut 9 is a sub-product of product 1 .So product 5 is sub-product of product 9.
plant Product code
A 1
B 5
B 9
A 9
A 2
Finally, i want to get a report like below:
P Sub-P
1 9
1 5
1 2