Join error type

[elfunambolo]

I have an error when I use Join, the left and right field are both number type in Excel and double type in Alteryx. This is the error:

I attach the workflow.

Thanks for support

Giovanni

[atcodedog05 · Accepted solution]

Hi @elfunambolo 

Please use select tool before the jointool and convert datatype to string or double. Please make sure datatype at both source was same.

[messi007 · Accepted solution]

@elfunambolo,

You have to add a select before the join and convert it to double :

It's not recommended to join on double fields.

Hope this helps,

Regards

[elfunambolo]

I see that I missing correct date format, in Excel are all in 2021, below are in1900...which is the way to restore it?

[atcodedog05]

Hi @elfunambolo 

Can you provide a sample input file which has the issue. We can take a look into it.