Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Unique and Only unique tool not giving correct result

8 - Asteroid

Thanks for the input. I am not fully sure about the difference b/w normal join and multiple join. I will try the normal join process for abc container and see how it is working. Thanks.


Hi @saikathalder 


It can come about when fields are called the same thing on both inputs, the join and union will align the columns, thus not having any nulls. The join multiple can't align the columns as they don't match and end up on different rows.


It's caught me out in the past, and I think this may have been what's happened to you. But without the full data it's hard to know for sure, so I could be wrong.


Good luck with the search