Make groups of strings (network mining or clustering?)

Hello,

I have this issue.

 

I have a table like this:

Column 1 Column 2
A B
B C
C A
X Y
Y Z

I want to have a new table like this one:

Column 1 Column 2 Aggregate column
A B A, B, C
B C A, B, C
C A A, B, C
X Y X, Y, Z
Y Z X, Y, Z

I think the solution should be arround https://tech.knime.org/network-mining

Or some clustering... but I cannot make it work.

 

Any ideas?

Thanks!

Hi,

Probably not the most elegant solution, but it does the job and it uses KNIME's network mining. See the attached workflow.

Cheers,
Marco.

THANK YOU!

That's great! Great solution!

Works like a charm.