AnsweredAssumed Answered

How to Compare two Collection variables

Question asked by koolgeex on Feb 22, 2017
Latest reply on Apr 5, 2017 by emha

I have two collection variables that looks similar to this:

Collection 1: A, B, C, D, E, F, G

Collection 2: B, D, F, G

Desired Results for Collection 3: A, C, E

 

In the third collection, I need to have all of the values that are NOT in Collection 2 - comparing the values against Collection 1.

 

Collection 1 is a complete list of departments. Collection 2 is a list of departments that have submitted a request. Collection 3 should be a list of departments that have NOT submitted a request. 

 

I know this should be possible and I know i will have to use a Collection Operation. I'm just not sure how to set it up properly. Any help would be AWESOME!

Outcomes