ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

Data Manipulation

8 - Asteroid

Hi Team,


I am stuck with a simple issue with huge data set 

I have attached sheet here for reference with a very simple data set for example.

In reality data set is very huge and I am getting incorrect results


Sheet 1 is fist input file.

Sheet 2 is second input file.


Can you please help to solve the issue.


Thanks in advance.:)

13 - Pulsar



Please see below:

But doing a join on name could give wrong result cause I suppose names are not unique.



Attached the workflow,

Hope this helps,



17 - Castor
17 - Castor

Hi @Polite123 


Can you provide a bit more information on what your trying to achieve?  What should the output look like?