Set functions like Except; Intersect

[SeanAdams]

While Alteryx does have a UNION set operator, it only currently has an Inclusive Union

the other two set operators, Intersect & Except, and an exclusive Union would be helpful if they can be added.

• Exclusive Union: Union two sets, but eliminate full duplicates (across the full row)
  • Although this can be done with a union, followed by a distinct - you have to do a distinct across all columns
  • This is the difference between SQL "Union" and SQL "Union ALL"
• Intersect:  This is the intersection of two sets - where the full row (all columns) are identical
• Except: This is where the row in 1 set is not in the other.

Intersect is particularly helpful for operations like looking at multi-column reference data to see if any fields at all have changed (like a slowly changing dimension).

CC: @rijuthav @jithinmony @HengHe @RajK @ydmuley @revathi @Deeksha @MPistone @Ari_Fuller @Arianna_Fuller @JoshKushner @samnelson @avinashbonu @Sunder_Sriram @Rahul_Thakur @Rahul_Singh

[Nezrin]

This would be really helpful - to have more functionalities within the union tool 

[Pradeep66]

This would be very helpful.

[binzidd]

+1

[arunkumark_21]

Agreed. This world be a great feature to have. Especially when it comes to testing 2 data sets for missing records