cancel
Showing results for 
Search instead for 
Did you mean: 

Sub Query Comparing two lists

chrisbodman
New Contributor II

Hi Everyone,

I’m a bit stuck. Basically, I retrieve a list of people who have a flag set to true (list A). Then I get a list of active cases from CRM (List B). Then I want to check if the customer from List A exists in List B, and if they dont, set the flag to false. I can retrieve both lists, but I’m not sure how I then compare them?

5 REPLIES 5

chrisbodman
New Contributor II

All sorted thank you. I used the combination of a join, followed by a filter to weed out the records I didnt need!

Thank you!