Comparing Results from one workflow to a new input in order to remove ineligible values
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much! This worked perfectly!
r
