Checking if a certain population is present in a masterfile

Hi all,

I need some help with a problem that I have. I need to check is a list of names(200) is present in a masterfile(1500). What is the easiest way to do this?

 

I just started using KNIME. So it's probably an easy thing if you know the program.

 

Thanks!

Hi Marc,

you could use a reference row filter. Filter the smaller table based on the big one. If after the filtering there are no more rows (empty table) all of them were included in the masterfile.

Best, Iris

Thank!