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.
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.
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.
@iamkamara_jpm use toNumber function and change datatype to double