cancel
Showing results for 
Search instead for 
Did you mean: 

Collection function needs EXCEPT

The Collection function has UNION and INTERSECTION but is missing EXCEPT. This would provide an easy way to filter arrays or objects and keep only items from the left that are missing from the right.

 

From https://www.essentialsql.com/:

 

UnionInsersectExcept.jpg

Status: New
Comments
DamoBird365
Community Champion

Hi there,

 

I believe it is possible to perform an except action on two arrays using the select action.  Please take a look at my video here

 

I would be interested to hear if this helps you at all?

 

Cheers

Damien