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

Polite123
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.:)

messi007
13 - Pulsar

@Polite123,

 

Please see below:

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

messi007_0-1617817865329.png

 

Attached the workflow,

Hope this helps,

Regards,

 

danilang
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?  

 

Dan

Labels