Make groups of strings (network mining or clustering?)

KNIME Analytics Platform
1

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!

2

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.

3

THANK YOU!

That's great! Great solution!

Works like a charm.

4

Hi !

Is there any other ways to make this solution on something outside Knime ?