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 