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

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Join tool doesnt give an output

die_Corinna
5 - Atom

Hello community,

I hope you might be able to help me with the following problem. 

I have to inputs - two excel sheets with different styles of dates. Consequently I tried to give them a consistent format- the regular one from Alteryx yyyy-MM-dd ) and typ (V_String). Now i added the Join Tool and what happens is this. do you know how i can manage this problem ? 😄

Capture.PNG

Thanks for your help !

JoeS
Alteryx
Alteryx

Are you able to confirm the data from the left and right of the join have the same values in and thus should match?

 

If you could send a screenshot of each with the fields in question that would be great.

die_Corinna
5 - Atom

yes I can confirm that the input is totally the same. 

I mean there is no order why 46 out of 278 entries match and the others dont !? 

 

maybe you know any trick i can try out ? ;D

thank you 

JoeS
Alteryx
Alteryx

Hi @die_Corinna

 

There shouldn't be any tricks, if the information is the same Alteryx will match them together 😉

 

Are you able to upload the two different inputs and your workflow so I can check the set up?