Compare Two Sets [Arrays]

Hello Everyone,

I am trying to achieve something which should be rather simple in Knime but unfortunately I couldn’t find a way yet.

23

I have one column (subset) with agreggated strings, and I have another column (set) with different aggregated strings. I just want to check whether the (subset) is a part of the (set) or not.

The order of the values inside the subset and the set doesn’t matter, I need to take every single value in the subset and check wether it exists in the set or not.

If all members from the subset exists then it is True otherwise it is false.

Can you please tell me how could I achieve that in Knime?

Thanks a lot in advance.

Hi @amrzahran,

my first throught would be to utilize the set operations in KNIME.
Which require two input tables.

I would use the cell splitter node to split the string by “,” into lists:

Then use the ungroup node to make them to rows:

And finally you can then use the set node to check for the different set operations

Something similar to your problem could be found here:

Maybe there is an easier solution in KNIME but that should be the basics how it should be possible :slight_smile:

5 Likes

Hi there @amrzahran,

well once you got columns as sets you can use Subset Matcher. Unfortunately it does more than you need. Compares each row from subset column with each row with set column. To eliminate extra rows use Joiner (right or left outer join depending on how you connect nodes to Joiner) with ID as joining column from Subset Matcher and RowID as joining column from original table and apply Rule-based Row Filter. There you wanna leave all rows where subset column match (means row wise comparison and match) or any column from Subset Matcher column missing (covers rows where no match). Then you only need to add 0 or 1 based on missing from any of above mentioned column. With Rule Engine for example.

A bit tricky but should work. Give it a try and if any questions feel free to ask. Can share workflow example if necessary as well :wink:

Br,
Ivan

1 Like