community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Set functions like Except; Intersect

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