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
Super User

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

tcvall86
Advocate I

@DamoBird365 
Thank you! I hade been looking into something similiar myself when I stumbled upon your solution to the problem here.
Needs some tweaking for each usecase (and in fairness it's combination of Selects and Filter Arrays but you already mention it on the blog post) 

 

But definitely a way to do it. Kudos!

 

Still would have been nice with an Except function out of the box