Collection function needs EXCEPT

[Bjorn]

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/:

[DamoBird365]

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]

@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