Regrouping all Elements that have something in Common

Hello !

I am a pretty new Knime user and I’m really enjoying this tool.

I am currently facing a situation which I cannot translate into a workflow.

My problem is similar to : Finding similarities in a huge table

I have table:
Invoice N# Box N#
A 1
A 2
B 2
B 3
C 4
D 3
E 5

I want to regroup all Invoices and Box Numbers that are linked via a similar box or invoice
This would get me the 3 following groups:
[A,B,D / 1,2,3], [C / 4], [E,5]

Do you know how i could do it ?

I tried pivoting on a constant value to get the one on one relationship matrix between Invoices and Boxes, but I don’t know how to proceed further.

Thank you very much.

I have found this solution, which would give me the result I want. But I cannot download the additional nodes…

There is an offline Repository to download. It is slow for installing, but it works.

1 Like

What solution are you referring to? Is it something on the KNIME Hub? Maybe you forgot to paste your link.

Which nodes are you unable to download? Do you receive any error messages during the process?

Sorry for the delay.

The solution found is the following: Make groups of strings (network mining or clustering?)

I had to manually update Knime in order to get the nodes that was used in the solution.

Everything is working perfectly :smiley:

1 Like

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