Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live!

Union tool doesn't remove duplicates!

Highlighted
7 - Meteor

Coming from a SQL background it was surprising to find out that  Alteryx Union tool doesn't remove duplicates from out put. Shouldn't we have a property in Union tool to select if output all records or output distinct records.

 

I know we can simply add a unique tool after union tool to get the desired output as well but just wanted to highlight  this.

Highlighted
12 - Quasar

How does SQL identify a duplicate if dataset 2 includes a field that does not exist in dataset 1?

 

Highlighted
8 - Asteroid

Coming from SQL world I understand your problem with Aletryx.

 

Unlike ANSI SQL, Alteryx does a UNION ALL and not UNION.

 

Once you UNION in alteryx, run a duplicate removal on all columns to get the same output as in SQL

Labels