Join error type
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Join
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I see that I missing correct date format, in Excel are all in 2021, below are in1900...which is the way to restore it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @elfunambolo
Can you provide a sample input file which has the issue. We can take a look into it.
