howto enumerate a list of organisations that exist in every year

I have data in the following format:
year; org_name (year=int ranging from 2001-2018;org_name=string)
I would like to apply a filter so that only records that have an org_name that appears in every year are included. How to do this in Knime?

If I understood your problem correctly. The attached workflow should do the job. I have illustrated the solution using a sample containing 4 years (2001 to 2004) and 4 Org_Name (a, b, c, d). The workflow will filter only Org_name ‘a’ which appears in all 4 years.list_of_org.knwf (11.2 KB)


A very elegant solution! Thanks.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.