Data type problem after a join
- 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
Hello,
Before my join I have my field "Rotation quotidienne" in float number:
Then after my join, while I put the field in "double" type. However, I have only integers in the column "Rotation Quotidienne":
Do you know why? Thanks in advance for your help.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Dupuy
I see there are summarize tool and formula tool before the Join.
Not sure what action has been taken there.
There might be some summarize done and the same would have been saved as INT16 or 32.
Then changing to double will not get back the decimal's.
Many thanks
Shanker V
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ShankerV
Thanks, I tried to put a select tool before summarize tool and formula tool.
And I'have something strange, In the input of the select tool i'have float in my colomne "rotation quotidienne" :
In the output of the select tool i'have integers in my colomne "rotation quotidienne" :
Thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Dupuy
Can you please share the workflow or mock the data's and share the workflow.
Will be easy to check.
Many thanks
Shanker V
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Dupuy I have a feeling it has something to do with those commas in the numbers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Dupuy, @Deano478 is right, using commas as your decimal separator is causing some field conversion issues. Try using a formula tool and the 'ToNumber' function instead. Here you can tell Alteryx that the decimal separator is a comma. You could also use a Multi-Field Formula tool to change all of your numeric fields at once.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ShankerV @FinnCharlton @Deano478 ,
Yes the problem was the commas. Thanks now it's working.
In France we use commas and not point for float 😣😂
Thanks !