Comparing Results from one workflow to a new input in order to remove ineligible values

Question

I have designed a workflow that provides me results.  YAY!  We will call this A.

However, a different data source (B) has a list of people who need to be excluded from results A.

Complicating this, results A may list a person twice because they are eligible for two different things. As I am writing this, I am thinking that I need to filter out the B people before I run workflow A.  How do I do this?

r

DataNath · Accepted Answer

Hey @rhearns1, if I'm understanding your ask right then you ought to just be able to bring your (B) dataset into workflow A and use a join to conduct a filter. Here's an example where we have one list:

And the second dataset (in your scenario this would be B) :

If we now conduct a join on these two datasets, using the name fields as the key, then we can just look at the top (L) output anchor of the Join tool to see those records that didn't find a match i.e. don't need excluding:

Hope this helps! Workflow attached for you to look over as well.