Compare Sets

[Mink]

Hi I want to know how to solve in KNIME a set compare like in JAVA.

I have 2 columns from Type Collection AggregatedValues

Table
AggregatedValuesSet1 AggregatedValuesSet2 samesets
[world, hello] [hello, world] true
[knime] [hello, world] false

How to solve this? Is there a way to do this with java snippet?

Thank you.

[DaveK]

Hi @Mink,

yes, you can do it using the Java Snippet node. I attached an example workflow.

Cheers
David

set_compare.knwf (17.6 KB)

[Mink]

Ok nice thank you and how is this possible to combine with the joiner node ?
these sets are in different table and only the same sets should match.

[DaveK]

Hi @Mink,

in the Joiner node you can just use the column containing the Set as joining column. Did you create your collections using the Create Collection Column node? If so, in the configuration of the Create Collection Column node you can specify the Collection type to be a Set under the Column Selection.