Hello @yanbeemwe,
you can give Subset Matcher node a try. Follow it with couple of nodes to get your desired output and you are done!
Take a look at workflow attached and if any questions feel free to ask
SubsetExample_ipazin.knwf (16.6 KB)
Welcome to KNIME Community!
Br,
Ivan