Converting numbers stored as text to numbers
- 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
As the title suggests, need help converting numbers stored as text in a column into numbers
Tried a few things but wanted to know the easiest way to do this? I know there's a text to column tool in Alteryx but it doesn't seem to work the same way it does in Excel
Sample Data
Note for the first line item, the text to column in excel removes the leading zero, which is also want I want Alteryx to do
Current Data | Desired Data Output |
07383834 | 7383834 |
84843435 | 84843435 |
Solved! Go to Solution.
- Labels:
- Best Practices
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks for the reply. I don't just want to trim the leading zeros, i want to convert all the values currently stored as text in one column to numbers, which will also procedurally take care of the leading zeros.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks for the reply. I don't just want to trim the leading zeros, i want to convert all the values currently stored as text in one column to numbers, which will also procedurally take care of the leading zeros.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@iamkamara_jpm use toNumber function and change datatype to double
