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

Alteryx designer Discussions

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

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

Learn More

Joins Bring Back Duplicates

Highlighted
Meteoroid

When I do join and add a variable it duplicates lines.  It seems that joins are not like joins in SQL?

Alteryx Partner

I can't run your workflow because I don't have the source file, but joins DO work like SQL .... you're essentially joining the same data together, so it will duplicate.

 

I don't know what the Union is doing because there is only 1 input.

Labels