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!