Alteryx Server Discussions

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

Join tool doesnt give an output

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 !

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.

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 

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?